Question

A recursive foreign key is a foreign key in a relation that references the ________ values of that same relation.

A) Non-primary key
B) Unique key
C) Primary key
D) Foreign key

Answer 1

A recursive foreign key references the primary key of the same table to create a relationship within the table, such as indicating employee-manager relationships.

Step-by-step explanation:

A recursive foreign key is a foreign key in a relation that references the primary key values of that same relation. This means that the table contains a foreign key that points to its own data, thereby creating a relationship within the same table. For example, in an employee table, a recursive foreign key could be used to indicate the manager of each employee, with the manager's information also being sored within the same employee table.