Which DELETE statement is valid?

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 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’);

Explanation:
The correct syntax for DELETE statement
DELETE [ FROM ] table
[ WHERE condition ];
Incorrect Answers :
A:
‘=’ is use in the statement and sub query will return more than one row.
Error Ora-01427: single-row sub query returns more than one row.B. Incorrect DELETE statement
D:
Incorrect DELETE statement
Refer: Introduction to Oracle9i: SQL, Oracle University Student Guide, Manipulating Data, p. 8-19