Intermediate
Database Management Systems
Q66 / 100
What is a database trigger and when should it be avoided?
Correct! Well done.
Incorrect.
The correct answer is B) Triggers automate actions but should be avoided when they create hidden logic, complex debugging scenarios, or performance issues — prefer application-layer constraints
B
Correct Answer
Triggers automate actions but should be avoided when they create hidden logic, complex debugging scenarios, or performance issues — prefer application-layer constraints
Explanation
Triggers make debugging hard (invisible logic), can cause cascading effects, and impact performance. Use for audit logging, but prefer application-layer logic for business rules to maintain transparency.
Progress
66/100