Intermediate
SQL
Q65 / 100
What does a "self-referencing foreign key" typically model, e.g. an "employees" table with a "manager_id" column referencing "employees.id"?
Correct! Well done.
Incorrect.
The correct answer is B) A hierarchical relationship within a single table, such as employees reporting to other employees
B
Correct Answer
A hierarchical relationship within a single table, such as employees reporting to other employees
Explanation
A self-referencing foreign key allows rows in a table to reference other rows in the same table, commonly used to represent tree/hierarchy structures like org charts.
Progress
65/100