Which of the following is the unique identifier of a record as defined by a primary key field?
Correct Answer: c) Entity Integrity
Entity Integrity ensures that each record in a table has a unique identifier, which is defined by the primary key. This rule prevents duplicate or null values in the primary key field, ensuring that each record is uniquely identifiable.
Domain Integrity – Ensures that data values in a column conform to a defined data type, range, or format (e.g., restricting an age column to numeric values). It does not enforce uniqueness.
Referential Integrity – Ensures that foreign keys correctly reference primary keys in related tables, preventing orphan records. It does not define the uniqueness of a record itself.
User-designed Integrity – A broad concept where users define custom rules to maintain data accuracy, but it is not directly related to primary keys.
No Payment Cards Needed
Discover a range of courses designed to provide you with the knowledge and skills needed to excel in your chosen field.
You don’t need one month to study and pass your test.
With Prepsaret, it takes you a few days to grasp all the concepts needed to pass your exams