← Quiz: Views, Triggers and Procedures: all 10 questions
Quiz: Views, Triggers and Procedures · Question 5 of 10
Which trigger timing can stop an invalid row from being inserted?
Which trigger timing can stop an invalid row from being inserted?
- A.AFTER INSERT
- B.AFTER DELETE
- C.AFTER UPDATE
- D.BEFORE INSERT
Answer & explanation
Correct answer: BEFORE INSERT
A BEFORE trigger runs before the row is written and can raise an error to abort it.
Can you get the rest right without peeking?
Take the timed Quiz: Views, Triggers and Procedures quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →