Which of the following ensures that records in associated tables have consistent data?
A) referential integrity
B) primary key
C) foreign key
D) Compact & Repair utility

Question

Quizplus · Accepted Answer

Referential integrity is a database feature that ensures that relationships between tables remain consistent. This means that a foreign key in one table must match a primary key in another table, and that if a primary key is deleted, any associated foreign keys are also deleted or set to null. Referential integrity guarantees that data in associated tables is kept in sync and prevents data inconsistencies. Primary keys and foreign keys are important components of referential integrity, but referential integrity encompasses the enforcement of these keys to ensure data consistency. The Compact & Repair utility is a feature that helps to fix errors in a database file, but it does not ensure the consistency of data in associated tables.

Which of the Following Ensures That Records in Associated Tables