nerdexam
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)
  • A
    15% (7)
  • B
    79% (38)
  • C
    2% (1)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice