Multiple choice technology databases

how many distinct triggers can be created on the table

  1. 12

  2. 4

  3. 2

  4. Unlimited
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle allows up to 12 distinct triggers per table: 4 timing levels (BEFORE/AFTER) × 2 events (INSERT/UPDATE/DELETE) × 2 levels (statement/row) for UPDATE, plus INSERT and DELETE at row and statement levels. This gives INSERT (2), UPDATE (4), DELETE (2), and 4 more variations totaling 12.

Keep practicing — related questions