DEVFYI - Developer Resource - FYI

How many types of database triggers can be specified on a table ? What are they ?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

482. How many types of database triggers can be specified on a table ? What are they ?

Insert Update Delete
Before Row o.k. o.k. o.k.
After Row o.k. o.k. o.k.
Before Statement o.k. o.k. o.k.
After Statement o.k. o.k. o.k.
If FOR EACH ROW clause is specified, then the trigger for each Row affected by the statement.
If WHEN clause is specified, the trigger fires according to the returned Boolean value.

(Continued on next question...)

Other Interview Questions