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

View Answer

Answer: CE

Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/

com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html