[Solved] Consider these tables:CREATE TABLE orders (order_id INT PRIMARY KEY);CREATE TABLE order_items ( item_id INT PRIMARY KEY, order_id INT, FOREIGN KEY (order_id) REFERENCES orders(order_id) ON UPDATE... | SQL

SQL - Table Constraints

Consider these tables:

CREATE TABLE orders (order_id INT PRIMARY KEY);
CREATE TABLE order_items (
  item_id INT PRIMARY KEY,
  order_id INT,
  FOREIGN KEY (order_id) REFERENCES orders(order_id) ON UPDATE RESTRICT
);

What will happen if you try to update orders.order_id that is referenced by order_items.order_id?

AThe order_items.order_id will be set to NULL.

BThe update will cascade to order_items.order_id.

CThe update will be rejected due to ON UPDATE RESTRICT.

DThe update will succeed and order_items.order_id remains unchanged.

Step-by-Step Solution

Solution:

Step 1: Understand ON UPDATE RESTRICT behavior
ON UPDATE RESTRICT prevents updating parent key if child rows reference it.
Step 2: Apply to orders and order_items
Trying to update orders.order_id referenced by order_items.order_id will be rejected.
Final Answer:
The update will be rejected due to ON UPDATE RESTRICT. -> Option C
Quick Check:
ON UPDATE RESTRICT blocks parent key update [OK]

Quick Trick: ON UPDATE RESTRICT blocks parent key changes [OK]

Common Mistakes:

MISTAKES

Thinking update cascades
Assuming child keys set to NULL
Believing update succeeds without change

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider these tables:

Step 1: Understand ON UPDATE RESTRICT behavior

Step 2: Apply to orders and order_items

Final Answer:

Quick Check:

Want More Practice?