Multiple choice technology programming languages

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert a row into the table? (Choose three.)A. INSERT INTO employeesVALUES ( NULL, 'John', 'Smith');B. INSERT INTO employees( first_name, last_name)VALUES( 'John', 'Smith');C. INSERT INTO employeesVALUES ( '1000', 'John', NULL);D. INSERT INTO employees (first_name, last_name, employee_id)VALUES ( 1000, 'John', 'Smith');E. INSERT INTO employees (employee_id)VALUES (1000);F. INSERT INTO employees (employee_id, first_name, last_name)VALUES ( 1000, 'John', ' ');

  1. A

  2. C,E

  3. C,E,F

  4. None

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Statement C inserts row with NULL for emp_id (valid if NOT NULL not specified), first_name='John', NULL last_name. Statement E inserts only emp_id=1000, other columns get NULL. Statement F inserts emp_id=1000, first_name='John', last_name=' '(space). A fails if emp_id is PK and NOT NULL. B and D have wrong column ordering in VALUES.