Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
Which DELETE statement is valid?
A. DELETE FROM employeesWHERE employee_id = (SELECT employee_idFROM employees);
B. DELETE * FROM employeesWHERE employee_id = (SELECT employee_idFROM new_employees);
C. DELETE FROM employeesWHERE employee_id IN(SELECT employee_idFROM new_employeesWHERE name = ‘Carrey’);
D. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_idFROM new_employeesWHERE last_name = ‘Carrey’);
|
Download Printable PDF. VALID exam to help you PASS. |
 |