Question

What are the after triggers?

(a) Triggers generated after a particular operation

(b) These triggers run after an insert, update or delete on a table

(c) These triggers run after an insert, views, update or delete on a table

(d) All of the mentioned

This question was addressed to me in an online quiz.

I would like to ask this question from Triggers topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct option is (b) These triggers run after an insert, update or delete on a table

The explanation is: AFTER TRIGGERS can be classified further into three types as: AFTER INSERT Trigger, AFTER UPDATE Trigger, AFTER DELETE Trigger.