🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.The row before the change and the row after the change
  2. B.The oldest and newest rows in the table
  3. C.The previous and next trigger
  4. 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 →