Which of the following statements is not true of triggers:
A) The DBMS will automatically recompile a trigger if a referenced object is deleted
B) Triggers should not perform integrity constraints that can otherwise be performed with CHECK constraints and assertions
C) The choice between using a database trigger versus an application trigger is usually fairly clear
D) A and C are both not true

Question

Quizplus · Accepted Answer

A) is incorrect because the DBMS does not automatically recompile a trigger if a referenced object is deleted; instead, it may invalidate the trigger. C) is also incorrect because the choice between using a database trigger versus an application trigger can often be complex and depends on various factors, including performance, maintainability, and the specific requirements of the application.

Which of the Following Statements Is Not True of Triggers