Triggers

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

• procedure

• function

• trigger

• package

Triggers are supported on

• procedure

• function

• cursor

• views

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 before an insert, views, update or delete on a table

• None of these

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

• BEFORE

• AFTER

• DURING

• INSTEAD OF

Triggers ________ enabled or disabled

• can be

• can not be

• delete

• always

Which prefixes are available to Oracle triggers?

• only :new

• only :old

• both :new and :old

• None of these

_______ is used to recreate, if trigger already exists.

• cursor

• trigger

• replace

• create

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, after insert

• for, insert

• none of these

Which data dictionary have information on triggers that are available in database?

• USER_OBJECTS

• USER_ERRORS

• USER_TRIGGERS

• None of these

Can COMMIT statement be executed as a part of trigger?

• Yes

• No