Question

Referential integrity refers to which one of the following?

• A. Primary Key
• B. Super key
• C. Foreign key
• D. Alternate key

Hint:

N/A

Answer 1

The Correct Option is C

- Primary Key: The primary key is used to uniquely identify records in a table, but it is not directly related to referential integrity.
- Super key: A super key is a set of attributes that can uniquely identify a record, but referential integrity specifically concerns foreign keys, not super keys.
- Foreign key: Referential integrity refers to the relationship between tables and ensures that a foreign key in one table correctly points to a valid record in another table. This prevents orphaned records and maintains the consistency of the database.
- Alternate key: An alternate key is a candidate key that is not selected as the primary key, but it is not directly related to referential integrity.
Therefore, the correct answer is 3. Foreign key.