A

Admin • 833.24K Points
Coach

Q. What is the maximum number of triggers that can apply to a single table?

  • (A) 14
  • (B) 10
  • (C) 12
  • (D) 16
  • Correct Answer - Option(C)
  • Views: 37
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

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

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.