An integrity constraint is a rule that ____.
A)is kept in an external file
B)can unintentionally be accessed by unauthorized users
C)can be accessed only by authorized users
D)data must follow in the database

Question

Quizplus · Accepted Answer

An integrity constraint is a rule that ensures that data in the database follows certain restrictions or conditions. It is a property of the database schema that must be maintained by the DBMS to enforce the correctness and consistency of the data. Therefore, the best choice is D. A is incorrect because integrity constraints are stored as part of the database schema, not in an external file. B is incorrect because integrity constraints are enforced by the DBMS, which only permits authorized users to access and modify the data. C is partially correct, but it only applies to the access control mechanisms that restrict user privileges to the data, not to the rules themselves.

An Integrity Constraint Is a Rule That ____