Question 26 :
Can views be specified in a trigger statement ?
Question 27 :
What are the values of :new and :old in Insert/Delete/Update Triggers ?
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?
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 ?
A trigger giving a SELECT on the table on which the trigger is written.
Question 30 :
What are constraining triggers ?
A trigger giving an Insert/Update on a table having referential integrity constraint on the triggering table.