In an UPDATE trigger, what does the OLD keyword represent?

easy📝 Conceptual Q1 of 15

SQL - Triggers

In an UPDATE trigger, what does the OLD keyword represent?

AThe new table structure

BThe row data after the update operation

CThe row data before the update operation

DThe trigger's execution time

Step-by-Step Solution

Solution:

Step 1: Understand the role of OLD in UPDATE triggers
The OLD keyword holds the original values of the row before the update happens.
Step 2: Compare OLD with NEW
NEW holds the updated values, so OLD must be the previous data.
Final Answer:
The row data before the update operation -> Option C
Quick Check:
OLD = before update [OK]

Quick Trick: OLD = old data before update, NEW = new data after update [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes