Solution:Step 1: Understand ON DELETE SET NULL actionThis option sets the foreign key column to NULL in child rows when the parent row is deleted.Step 2: Apply to given tablesDeleting a Products row sets ProductID to NULL in related Sales rows.Final Answer:The ProductID in Sales is set to NULL. -> O

[Solved] You have two tables:CREATE TABLE Products (ProductID INT PRIMARY KEY, Name VARCHAR(50));CREATE TABLE Sales (SaleID INT PRIMARY KEY, ProductID INT, FOREIGN KEY (ProductID) REFERENCES... | SQL

SQL - Table Relationships

You have two tables:
CREATE TABLE Products (ProductID INT PRIMARY KEY, Name VARCHAR(50));

CREATE TABLE Sales (SaleID INT PRIMARY KEY, ProductID INT, FOREIGN KEY (ProductID) REFERENCES Products(ProductID) ON DELETE SET NULL);

If a product is deleted from Products, what happens to the related ProductID in Sales?

AThe ProductID in Sales is set to NULL.

BThe related Sales rows are deleted.

CThe delete is blocked by the foreign key.

DThe ProductID in Sales remains unchanged.

Step-by-Step Solution

Solution:

Step 1: Understand ON DELETE SET NULL action
This option sets the foreign key column to NULL in child rows when the parent row is deleted.
Step 2: Apply to given tables
Deleting a Products row sets ProductID to NULL in related Sales rows.
Final Answer:
The ProductID in Sales is set to NULL. -> Option A
Quick Check:
ON DELETE SET NULL sets child keys to NULL [OK]

Quick Trick: ON DELETE SET NULL nullifies child foreign keys [OK]

Common Mistakes:

MISTAKES

Assuming child rows are deleted
Thinking delete is blocked
Believing child keys remain unchanged

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

You have two tables:

Step 1: Understand ON DELETE SET NULL action

Step 2: Apply to given tables

Final Answer:

Quick Check:

Want More Practice?