Multiple choice technology databases

What part of a DB trigger determines the number of times a trigger body executes?

  1. Trigger type

  2. Trigger body

  3. Trigger event

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

The trigger type (statement-level vs row-level) determines execution frequency. Statement-level triggers fire once per SQL statement regardless of rows affected. Row-level triggers fire once for EACH row processed. Trigger timing (before/after) determines WHEN it fires relative to the event, not HOW MANY times. The body contains the logic, and the event (INSERT/UPDATE/DELETE) determines WHAT causes it to fire.

Keep practicing — related questions