[Solved] You have this foreign key constraint:FOREIGN KEY (ProductID) REFERENCES Products(ProductID) ON DELETE SET NULLWhich error will occur if you try to delete a product that is referenced by an order, but... | SQL

SQL - Table Relationships

You have this foreign key constraint:

FOREIGN KEY (ProductID) REFERENCES Products(ProductID) ON DELETE SET NULL

Which error will occur if you try to delete a product that is referenced by an order, but the ProductID column in Orders is defined as NOT NULL?

ADelete fails due to NOT NULL constraint violation

BDelete succeeds and sets ProductID to NULL

CDelete succeeds and removes the order row

DDelete succeeds without affecting Orders

Step-by-Step Solution

Solution:

Step 1: Understand ON DELETE SET NULL behavior
This option sets the foreign key column to NULL in referencing rows when the referenced row is deleted.
Step 2: Check NOT NULL constraint conflict
If the foreign key column is NOT NULL, setting it to NULL violates the column constraint, causing the delete to fail.
Final Answer:
Delete fails due to NOT NULL constraint violation -> Option A
Quick Check:
SET NULL + NOT NULL column = delete fails [OK]

Quick Trick: SET NULL fails if foreign key column is NOT NULL [OK]

Common Mistakes:

MISTAKES

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You have this foreign key constraint: