您当前的位置：优技教育 > ocp考试 >

ocp题库怎么背：11g-051-V9.02-第185题

来源：优技教育

ocp题库怎么背：11g-051-V9.02-第185题，完整题库请点击这里联系老师咨询了解

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

Answer: D

试题解析：

这里主要注意department_id只能是20或者50，所以需要department_id IN (20,50) WITH CHECK OPTION

精华阅读