Which statement regarding triggers is true?
A.
Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
B.
Triggers cannot be modified, they must be dropped and recreated with new definitions.
C.
Adding a trigger to a table that already has rows in it will cause triggered actions to be
fired.
D.
Triggers can only be fired one time per statement irrespective of the number of rows
affected.
B)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0020253.html
0
0
>>-CREATE–+————+–TRIGGER–trigger-name—————->
‘-OR REPLACE-‘
0
0
D
0
0