Unit-V-Trigger-II-Q & A

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