How can a BEFORE UPDATE trigger be used together with a BEFORE INSERT trigger to maintain a column's value always uppercase?

hard📝 Application Q9 of 15

SQL - Triggers

How can a BEFORE UPDATE trigger be used together with a BEFORE INSERT trigger to maintain a column's value always uppercase?

AOnly BEFORE INSERT modifies the column, BEFORE UPDATE does nothing

BBoth triggers modify NEW.column to UPPER(NEW.column) before saving

COnly BEFORE UPDATE modifies the column, BEFORE INSERT does nothing

DUse AFTER triggers to modify the column after saving

Step-by-Step Solution

Solution:

Step 1: Understand data modification timing
BEFORE INSERT and BEFORE UPDATE triggers run before saving new or updated rows.
Step 2: Modify NEW.column in both triggers
To keep column uppercase always, both triggers must convert NEW.column to uppercase.
Final Answer:
Both triggers modify NEW.column to UPPER(NEW.column) before saving -> Option B
Quick Check:
Use BEFORE triggers on insert and update to enforce data format [OK]

Quick Trick: Modify NEW values in both BEFORE INSERT and UPDATE triggers [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