Certified Data Management Professional CDMP Associate · Free Practice Question Medium
Question 14
In a relational database, what is meant by "referential integrity," and why is it important?
-
A
It ensures that all records in a database are unique.
-
B
It restricts access to certain tables based on user permissions.
-
C
It automates backup processes for critical tables.
-
D
It guarantees that relationships between tables remain consistent through foreign key constraints.
Reveal correct answer
Correct answer: D
Explanation
Referential integrity ensures that relationships between tables in a relational database remain consistent through foreign key constraints. This means that any foreign key value must correspond to an existing primary key value in another table, preventing orphaned records and maintaining accurate relationships within the database.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
