UGC NET Questions (Paper – 1)

A foreign key is used to link related records across tables by referencing the primary key in another table. It supports referential integrity by ensuring that relationships between data remain consistent. This design allows relational databases to model complex structures. Therefore, the key described is a foreign key.

Option A:
Option A, primary, key uniquely identifies records within its own table but does not specifically represent a reference to another table.

Option B:
Option B is correct because foreign key is defined as a field that points to a primary key in another table, establishing relationships.

Option C:
Option C, composite, key refers to a key made of more than one field, which can be primary or candidate but is not necessarily a cross table reference.

Option D:
Option D, super, key is any set of attributes that uniquely identifies rows and is broader than the specific concept of foreign keys.