Multiple choice technology databases

what is the maximum number of triggers can apply on a single table

  1. 4

  2. no limit

  3. 24

  4. 12
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A maximum of 12 triggers can be defined on a single table in a database, covering combinations of INSERT, UPDATE, DELETE operations with BEFORE and AFTER timing. This limit exists due to the finite combinations of trigger events and timing options. Options A, B, and C do not represent the actual trigger limit.

AI explanation

This is a legacy trivia-bank question referencing Oracle 7.0, where only 12 distinct trigger combinations (INSERT/UPDATE/DELETE x BEFORE/AFTER x ROW/STATEMENT level) could be defined per table. Modern Oracle, MySQL 5.7.2+, and SQL Server have no such hard limit, but within the context of this question the expected answer is 12.

Keep practicing — related questions