问题:
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')'
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? ()
● 参考解析
本题暂无解析