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