WorksheetsDatabase Systems - DML Triggers (Review game)
Total questions: 10
Worksheet time: 5mins
A trigger is a stored database object. True or False?
True
False
Triggers should be invoked. True or False
True
False
Which among the following events causes a trigger to fire?
Create or Alter statements
Commit Statement
What is a type of trigger that fires once for each row affected by the triggering statement?
Row level trigger
Statement level trigger
How do you define a trigger?
Defined with CREATE TRIGGER
Defined with a CREATE PROCEDURE
Implicitly invoking the trigger
Is the commit, save point, and rollback allowed in triggers?
Yes
No
Which of the following statement will disable a trigger?
Drop trigger trigger_name;
Alter trigger trigger_name disable;
Alter trigger trigger_name compile;
Which among the following is NOT a trigger timing?
BEFORE
AFTER
INSTEAD OF
INSTEAD
This type of trigger is the default type.
statement level trigger
row level trigger
What is an object schema that fires when its sees a triggering event?
Triggers
Procedures
Functions
Anonymous blocks
