Home » Oracle » 1z0-061 » 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’);
Correct Answer: C
Explanation/Reference:
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
Download Printable PDF. VALID exam to help you PASS.
|
|