Multiple choice technology databases

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? (Choose three)

  1. INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

  2. . INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

  3. INSERT INTO employees VALUES ('1000','JOHN','NULL');

  4. INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

  5. . INSERT INTO employees (employee_id) VALUES (1000);

  6. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
Reveal answer Fill a bubble to check yourself
C,E,F Correct answer
Explanation

Option C inserts numeric 1000 into employee_id (NUMBER column) and strings for names. Option E inserts only the employee_id with NULLs for name columns (valid for nullable columns). Option F inserts all three columns with proper values. Options A and B fail because employee_id is PRIMARY KEY (cannot be NULL, and must provide all NOT NULL columns). Option D has syntax errors with quotes.

Keep practicing — related questions