Multiple choice

How many triggers can be applied to a single table in Oracle?

  1. 10

  2. 12

  3. 15

  4. 16
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle allows 12 triggers per table: one BEFORE and one AFTER for each of the six operations (INSERT, UPDATE, DELETE, plus their row-level variants INSERT ROW, UPDATE ROW, DELETE ROW). This gives maximum flexibility for enforcing business rules at different execution points.

Keep practicing — related questions