IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 34

Which of the following statements about triggers are TRUE? (Choose two.)

Answer options

• A. There is a limit of 8 for the maximum number of cascading trigger activations
• B. Triggers can be activated as a result of changes due to referential constraint enforcement
• C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
• D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
• E. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Correct answer: B, D

Explanation

Option B is correct because triggers can indeed be activated by referential constraint enforcement. Option D is also correct as constraints are applied during the execution phase of triggers. Options A, C, and E are incorrect since they contain inaccuracies regarding cascading triggers, the allowance of INSTEAD OF triggers, and the order of trigger activation.