PrepAway - Latest Free Exam Questions & Answers

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

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

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

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html


Leave a Reply