← Quiz: Views, Triggers and Procedures: all 10 questions
Quiz: Views, Triggers and Procedures · Question 4 of 10
Inside an UPDATE trigger, what do OLD and NEW refer to?
Inside an UPDATE trigger, what do OLD and NEW refer to?
- A.The row before the change and the row after the change
- B.The oldest and newest rows in the table
- C.The previous and next trigger
- D.The old and new table names
Answer & explanation
Correct answer: The row before the change and the row after the change
OLD.price is the price before the update; NEW.price is the price after.
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 →