Maximum number of triggers applied to a single table - PL/SQL Subprograms

Q.  What is the maximum number of triggers that can apply to a single table?
- Published on 19 Oct 15

a. 14
b. 10
c. 12
d. 16

ANSWER: 12
 
We can have N number of triggers on a table but the maximum type of triggers on a single table can be 3*2*2=12 that is the division is done as
Insert/Update/Delete= 3
Before/After= 2
Row Level/Statement Level=2

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)