Triggers DBMS Questions and Answers

Triggers - DBMS Questions and Answers

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.

Triggers DBMS Questions

Online Test Name	Triggers
Exam Type	Multiple Choice Questions
Category	Computer Science Engineering Quiz
Number of Questions	10

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 & Explanation

Answer: Option B

Explanation:

Triggers

Triggers are automatically generated when a particular operation takes place.

Workspace

Report Error

2. Trigger are supported in

A. Delete
B. Update
C. Views
D. All of the mentioned

Answer & Explanation

Answer: Option C

Explanation:

Views

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

Workspace

Report Error

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 & Explanation

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.

Workspace

Report Error

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 & Explanation

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.

Workspace

Report Error

5. The variables in the triggers are declared using

A. -
B. @
C. /
D. /@

Answer & Explanation

Answer: Option B

Explanation:

@ declare @empid int; where empid is the variable.