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 versus row-level) determines if a database trigger executes once for the entire triggering statement or repeatedly for each modified row. Trigger body contains the executed code, events trigger it, and timing determines when (BEFORE/AFTER), but none of these control the execution frequency per operation.

Keep practicing — related questions