This is the DBMS questions and answers section on "Triggers" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.
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.
- A. Procedures
- B. Triggers
- C. Functions
- D. None of the mentioned
Answer: Option B
Explanation:
Triggers
Triggers are automatically generated when a particular operation takes place.
2. Trigger are supported in
- A. Delete
- B. Update
- C. Views
- D. All of the mentioned
Answer: Option C
Explanation:
Views
The triggers run after an insert, update or delete on a table. They are not supported for 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.
- A. for insert, on
- B. On, for insert
- C. For, insert
- D. Both a and c
Answer: Option B
Explanation:
On, for insert
The triggers run after an insert, update or delete on a table. They are not supported for views.
4. 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. Both b and c
Answer: Option B
Explanation:
These triggers run after an insert, update or delete on a table
AFTER TRIGGERS can be classified further into three types as: AFTER INSERT Trigger, AFTER UPDATE Trigger. ,AFTER DELETE Trigger.
5. The variables in the triggers are declared using
Answer: Option B
Explanation:
@
declare @empid int; where empid is the variable.
