SQL - Triggers
Which of the following is a valid reason to use a
DELETE trigger in a database?Which of the following is a valid reason to use a DELETE trigger in a database?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify common uses of DELETE triggers
DELETE triggers often log deletions or maintain related data.Step 2: Evaluate options
Logging deleted rows is a common and valid use; speeding deletion or preventing all deletes is not typical.Final Answer:
To automatically log deleted rows for auditing -> Option AQuick Check:
DELETE trigger use = logging deletions [OK]
Quick Trick: Use DELETE triggers to log or audit deletions [OK]
Common Mistakes:
- Thinking triggers speed up deletes
- Assuming triggers block all deletes
- Confusing DELETE triggers with INSERT triggers
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes