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

What of the following is TRUE about triggers?

Answer options

• A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
• B. Triggers can be used to perform data manipulation operations against complex views
• C. Triggers can only be used to execute logic before or after appropriate SQL statements
• D. Only one trigger for a particular event and activation time can be created for a particular table

Correct answer: A

Explanation

Option A is correct because triggers are indeed activated by INSERT, UPDATE, DELETE, and SELECT statements. Options B and C are incorrect as triggers cannot perform operations on views and can execute logic at various points. Option D is also false since multiple triggers can be created for different events on the same table.