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?

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 employees
VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000, NULL, &did);

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

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 (SELECT *
FROM employees
WHERE department_id IN (20,50)
WITH CHECK OPTION)
VALUES (emp_id_seq.NEXTVAL, ‘&ename’, ‘&jobid’, 2000, NULL, &did);

E.
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);



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Sadiq Al Sahaf (Sojib)

Sadiq Al Sahaf (Sojib)

Correct Answer: D

Akhil

Akhil

Why not option E even that is correct.