| Snaprecruit.com

| Snaprecruit.com

Interview question based on skill :

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

Correct Answer is : Triggers

2. Triggers are supported in

Correct Answer is : Views

3. 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.

Correct Answer is : On, for insert

4. What are the after triggers?

Correct Answer is : These triggers run after an insert, update or delete on a table

5. The variables in the triggers are declared using

Correct Answer is : @