Which DELETE statement is valid?

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
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



Leave a Reply 0

Your email address will not be published. Required fields are marked *