Solution:Step 1: Understand ON DELETE SET NULL behaviorThis option means when the referenced row is deleted, the foreign key column in dependent rows is set to NULL.Step 2: Apply to Employees and DepartmentsDeleting a department sets DeptID to NULL in Employees who referenced it, keeping employees b

[Solved] You have two tables:CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName VARCHAR(50), DeptID INT, FOREIGN KEY (DeptID)... | SQL

SQL - Table Relationships

You have two tables:
CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));

CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName VARCHAR(50), DeptID INT, FOREIGN KEY (DeptID) REFERENCES Departments(DeptID) ON DELETE SET NULL);

If a department is deleted, what happens to employees linked to that department?

ATheir DeptID is set to NULL automatically

BThe delete is blocked and fails

CEmployees linked to that department are deleted

DNothing happens; DeptID remains unchanged

Step-by-Step Solution

Solution:

Step 1: Understand ON DELETE SET NULL behavior
This option means when the referenced row is deleted, the foreign key column in dependent rows is set to NULL.
Step 2: Apply to Employees and Departments
Deleting a department sets DeptID to NULL in Employees who referenced it, keeping employees but removing the link.
Final Answer:
Their DeptID is set to NULL automatically -> Option A
Quick Check:
ON DELETE SET NULL means foreign keys become NULL [OK]

Quick Trick: ON DELETE SET NULL clears foreign keys on delete [OK]

Common Mistakes:

MISTAKES

Assuming delete blocks or cascades employees
Thinking employees get deleted automatically
Ignoring ON DELETE action effects

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 behavior

Step 2: Apply to Employees and Departments

Final Answer:

Quick Check:

Want More Practice?