Solution:Step 1: Analyze the trigger conditionIf NEW.price is less than 0, the trigger sets it to 0.Step 2: Apply the condition to the update valueSince -50 < 0, NEW.price becomes 0 before update.Final Answer:The price will be set to 0 -> Option CQuick Check:BEFORE UPDATE can enforce value constr

[Solved] Given this trigger:CREATE TRIGGER trg_before_update BEFORE UPDATE ON products FOR EACH ROW BEGIN IF NEW.price < 0 THEN SET NEW.price = 0;... END;What happens if you update a product's price to -50? | SQL

SQL - Triggers

Given this trigger:

CREATE TRIGGER trg_before_update BEFORE UPDATE ON products FOR EACH ROW BEGIN IF NEW.price < 0 THEN SET NEW.price = 0; END IF; END;

What happens if you update a product's price to -50?

AThe update will be rejected with an error

BThe price will be set to -50

CThe price will be set to 0

DThe price will remain unchanged

Step-by-Step Solution

Solution:

Step 1: Analyze the trigger condition
If NEW.price is less than 0, the trigger sets it to 0.
Step 2: Apply the condition to the update value
Since -50 < 0, NEW.price becomes 0 before update.
Final Answer:
The price will be set to 0 -> Option C
Quick Check:
BEFORE UPDATE can enforce value constraints [OK]

Quick Trick: BEFORE UPDATE triggers can correct invalid values before saving [OK]

Common Mistakes:

Assuming negative price is saved
Expecting an error instead of correction
Thinking price stays unchanged

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given this trigger:

Step 1: Analyze the trigger condition

Step 2: Apply the condition to the update value

Final Answer:

Quick Check:

Want More Practice?