Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

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?
A . TRUNCATE employee;
B . DELETE FROM employee;
C . DELETE FROM employee WHERE…;
D . TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

View Answer

Answer: B

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_delete.html