A user is the database administrator for a company. The user has been asked to implement an integrity rule that states every table must have a primary key and that the column or columns chosen to be the primary key must be unique and not null. Which integrity requirement is the user implementing?

IT Questions Bank › Category: Cybersecurity Essentials › A user is the database administrator for a company. The user has been asked to implement an integrity rule that states every table must have a primary key and that the column or columns chosen to be the primary key must be unique and not null. Which integrity requirement is the user implementing?

domain integrity
entity integrity
anomaly integrity
referential integrity

Explanation: There are three major database integrity requirements: entity, referential, and domain integrity.

Exam with this question: Cybersecurity Essentials Chapter 5 Quiz Answers