Which INSERT statement meets the above requirements?

Examine the structure of the EMPLOYEES table: You want to create a SQL script file that
contains an INSERT statement. When the script is run, the INSERT statement should insert
a row with the specified values into the EMPLOYEES table. The INSERT statement should
pass values to the table columns as specified below: Which INSERT statement meets the
above requirements?

A.
INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND
department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, ‘&ename’,
‘&jobid’, 2000, NULL, &did);

B.
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH
CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000, NULL, &did);

C.
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50))
VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000, NULL, &did);

D.
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000,
NULL, &did);

E.
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000,
NULL, &did IN (20,50));