Oracle
1Z0-007 · Question #58
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE statement is valid?
The correct answer is C. DELETE FROM employees. The correct syntax for DELETE statement DELETE [ FROM ] table [ WHERE condition ];
Manipulating Data (DML)
Question
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
Which DELETE statement is valid?
Exhibit
Options
- ADELETE FROM employees
- BDELETE * FROM employees
- CDELETE FROM employees
- DDELETE * FROM employees
How the community answered
(54 responses)- A6% (3)
- B11% (6)
- C80% (43)
- D4% (2)
Explanation
The correct syntax for DELETE statement DELETE [ FROM ] table [ WHERE condition ];
Topics
#DELETE syntax#DML#row removal#SQL grammar
Community Discussion
No community discussion yet for this question.