To control complexity among a collection of triggers,which guideline(s)should be followed?
A) Use data manipulation statements primarily in BEFORE triggers.
B) For triggers that fire on UPDATE statements, do not list the columns to which the trigger applies.
C) Be cautious about creating triggers on tables affected by actions on referenced rows.
D) All of the above.

Question

Quizplus · Accepted Answer

Creating triggers on tables that reference other tables can lead to a complex web of triggers that are difficult to manage and debug. It's important to be cautious and consider the potential impact before creating triggers on these tables. Option A is not always true as there may be scenarios where data manipulation statements can also be used in AFTER triggers. Option B is not a guideline for controlling complexity among triggers.

To Control Complexity Among a Collection of Triggers,which Guideline(s)should Be