Multiple choice technology databases

What is meant by cascading in the context of the database triggers?

  1. When a trigger fires, a SQL statement within its trigger action potentially can fire other triggers

  2. When a trigger fires, a SQL statement within its trigger action potentially can update other tables

  3. When a trigger fires, a SQL statement within its trigger action potentially can fire other stored procedures

  4. When a trigger fires, a SQL statement within its trigger action potentially can drop other tables
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Cascading in database triggers refers to the domino effect where one trigger's action fires another trigger, which may fire yet another, creating a chain reaction. Option A correctly defines this phenomenon. Options B, C, and D describe normal database operations (updates, procedure calls, drops) rather than the specific cascading behavior of trigger chains.

Keep practicing — related questions