【单选题】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...
【简答题】A.Employees can have more control over their lives. B.Employees become much more dependent on the companies they work for. C.Management teams have become less hierarchical. D.Employees can work for di...
【单选题】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...
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 name = 'carrey');