IBM
C2090-320 · Question #88
Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?
The correct answer is B. DELETE FROM employee. See the full explanation below for the reasoning.
Question
Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?
Options
- ATRUNCATE employee;
- BDELETE FROM employee;
- CDELETE FROM employee WHERE...;
- DTRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;
How the community answered
(48 responses)- A15% (7)
- B79% (38)
- C2% (1)
- D4% (2)
Community Discussion
No community discussion yet for this question.