Question

Given the students table which was created by the following SQL-query:

CREATE TABLE STUDENTS (
    ID INTEGER PRIMARY KEY,
    FIRST_NAME VARCHAR(50) NOT NULL,
    LAST_NAME VARCHAR(50) NOT NULL,
    ADDRESS VARCHAR(100)
)

Select all queries that will add a record to this table.

Cosmo · Accepted Answer

FIRST_NAME and LAST_NAME columns have a NOT NULL constraint imposed on each of them making it impossible to write NULL values in them.

Cosmo · Accepted Answer

INSERT INTO students(id, first_name, last_name) VALUES (1, 'Name', 'Surname');

Cosmo · Accepted Answer

INSERT INTO students VALUES (3, 'Name', 'Surname', NULL);

Cosmo · Answer

INSERT INTO students(id, first_name) VALUES (2, 'Name');

Cosmo · Answer

INSERT INTO students VALUES (4, NULL, 'Surname', NULL);

Follow CodeGalaxy

Mobile Beta