Set - 10

Question 26 :

Can views be specified in a trigger statement ?

Answer :

No


Question 27 :

What are the values of :new and :old in Insert/Delete/Update Triggers ?

Answer :

INSERT : new = new value, old = NULL
DELETE : new = NULL, old = old value
UPDATE : new = new value, old = old value


Question 28 :

What are cascading triggers? What is the maximum no of cascading triggers at a time?

Answer :

When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.


Question 29 :

What are mutating triggers ?

Answer :

A trigger giving a SELECT on the table on which the trigger is written.


Question 30 :

What are constraining triggers ?

Answer :

A trigger giving an Insert/Update on a table having referential integrity constraint on the triggering table.