Exam C2090-616 topic 1 question 11 discussion

The answer B is correct because you can use triggers, along with referential constraints and CHECK constraints, to enforce data integrity rule. The answer D is correct because : - BEFORE triggers are activated before an update or INSERT operation, and the values that are being updated or inserted can be changed before the database data is modified in the table. - AFTER triggers are activated after an INSERT, UPDATE, or DELETE operation and are used to maintain relationships between data or to keep audit trail information.

The answer E is wrong because the activation of a trigger results in the running of its associated triggered action. Every trigger has exactly one triggered action which, in turn, has two components: an optional triggered action condition or WHEN clause, and a set of triggered statement(s). Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0020231.html

The answer C is wrong because only one INSTEAD OF trigger is allowed for each kind of operation on a given subject view (SQLSTATE 428FP).

The answer A is wrong. YOur maximum is 16. The maximum nesting level for triggers is 16. That is, the maximum number of cascading trigger activations is 16. A trigger activation refers to the activation of a trigger upon a triggering event, such as insert, update, or delete of data in a column of a table, or generally to a table. (reference https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0020227.html)