What of the following is TRUE about triggers?
What of the following is TRUE about triggers?
Triggers can indeed be used to perform data manipulation operations against complex views. Specifically, INSTEAD OF triggers are designed for this purpose, as they allow actions to be taken in place of the usual operations on views. This feature makes it possible to manage and manipulate data within complex views more efficiently.
The answer B is correct. You have INSTEAD OF trigger which can be used to perform data manipulation operations against complex views
The answer D is not correct because you can have several "UPDATE OF column-name" triggers by columns. In this case, the trigger will only activated by the update of a column that is identified in the column-name list.
The answer C is not correct because, the triggers can be also used to enforce data integrity rules.
The answer A is wrong. Triggers are not activated by SELECT statement but only UPDATE, DELETE, INSERT statement.
B is correct https://www.ibm.com/docs/en/db2/10.1.0?topic=triggers-instead