Question

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

(a) for insert, on

(b) On, for insert

(c) For, insert

(d) None of the mentioned

This question was posed to me in an online interview.

My question comes from Triggers topic in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

The correct answer is (b) On, for insert

The explanation is: The triggers run after an insert, update or delete on a table. They are not supported for views.