NEW
Font size
WorksheetsUnit-V-Trigger-II-Q & A
Total questions: 9
Worksheet time: 3mins
Choose the correct syntax for Triggers
keyword ________ is optional, and we should only use it to modify a trigger.
INSTEAD
CREATE
REPLACE
BEFORE
_______________ is fired before execution of a DML statement.
CREATE
BEFORE
AFTER
INSTEAD
An _________ trigger is used to modify a table that cannot be modified through a view.
BEFORE OF
AFTER OF
REPLACE OF
INSTEAD OF
Triggers can be defined on the_____?
table
view
schema
All of the choice mentioned
Which of the following specifies when the trigger will be executed?
BEFORE
AFTER
INSTEAD OF
All of the above
The default extension for an Oracle SQL*Plus file is:
.txt
.html
.css
.sql
Trigger is special type of __________ procedure.
Function
Stored
View
Table
Point out the wrong statement.
We can have an INSTEAD OF insert/update/delete trigger on a table that successfully executed
DML Triggers are used to evaluate data after data manipulation using DML statements
INSTEAD OF triggers cause their source DML operation to skip
AFTER triggers cause their source DML operation to skip
