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

  • (A) 14
  • (B) 10
  • (C) 12
  • (D) 16
💬 Discuss
✅ Correct Answer: (C) 12
Explanation: 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

Published by Akshay Kulkarni ⭐ 3.46K Points at 22-Oct-2022 04:22 pm in MySQL

Explanation by: Akshay Kulkarni
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

💬 Discussion

📊 Question Analytics

👁️
202
Total Visits
📽️
4 y ago
Published
🎖️
Akshay Kulkarni
Publisher
📈
81%
Success Rate