ocp题库怎么背：11g-051-V9.02-第192题
来源：优技教育
ocp题库怎么背：11g-051-V9.02-第192题，完整题库请点击这里联系老师咨询了解
192.Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
Which DELETE statement is valid?
A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM new_employees);
C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carrey’);
D. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE name = ‘Carrey’);
Answer: C
试题解析：
delete删除表中记录是使用delete form表名，而不是delete * form 表名
另外子查询中必须为返回单条的记录，所以C正确。
精华阅读