试题详情
单项选择题 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?（）

A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

B、DELETE * FROM employees WHERE 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 employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题