A recursive foreign key is a:
2007
A recursive foreign key is a:
- A.
references a relation
- B.
references a table
- C.
references its own relation
- D.
references a foreign key
Attempted by 317 students.
Show answer & explanation
Correct answer: C
A recursive foreign key is a constraint where a column references the primary key of the same table. This enables self-referencing relationships, such as an employee hierarchy where a manager is also an employee in the same table.
A video solution is available for this question — log in and enroll to watch it.