Quiz on Triggers in SQL

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updating of data.

• Procedures

• Triggers

• Functions

• None of the mentioned

Triggers are not supported for

• Delete

• Update

• Views

• Insert

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.

• for insert, on

• On, for insert

• For, insert

• None of the mentioned

What are the after triggers?

• Triggers generated after a particular operation

• These triggers run after an insert, update or delete on a table

• These triggers run after an insert, views, update or delete on a table

• All of the mentioned

The variables in the triggers are declared using

• –

• @

• /

• /@

The default extension for an Oracle SQL*Plus file is:

• .txt

• .pls

• .ora

• .sql

Which of the following is NOT an Oracle-supported trigger?

• BEFORE

• DURING

• AFTER

• INSTEAD OF

What are the different in triggers?

• Define, Create

• Drop, Comment

• Insert, Update, Delete

• All of the mentioned

Triggers ________ enabled or disabled

• Can be

• Cannot be

• Ought to be

• Always

Which prefixes are available to Oracle triggers?

• : new only

• : old only

• Both :new and : old

• Neither :new nor : old