1D0-541 Exam QuestionsBrowse all questions from this exam

1D0-541 Exam - Question 27


Which type of relational integrity is violated if a primary key in a database has a null value?

Show Answer
Correct Answer: A

Entity integrity is violated when a primary key attribute in a database table has a null value. Entity integrity ensures that the primary key of a table uniquely identifies each row, and it should not contain any null values. A primary key is used to uniquely identify a record in a table, and having null values in the primary key would result in ambiguity and violation of the uniqueness constraint.

Discussion

1 comment
Sign in to comment
dayogreatsOption: A
Jul 31, 2023

A. Entity integrity Entity integrity is violated when a primary key attribute in a database table has a null value. Entity integrity ensures that the primary key of a table uniquely identifies each row, and it should not contain any null values. A primary key is used to uniquely identify a record in a table, and having null values in the primary key would result in ambiguity and violation of the uniqueness constraint.