MENU
Which type of relational integrity is violated if a primary key in a database has a null value?
Suggested Answer: A
Get Premium 1D0-541 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
18 comments · newest first
CH
Cherilyn
10 months ago
I always mix those up, thanks for clarifying!
MO
Mozell
10 months ago
Wait, is that really the case? I thought it was referential integrity.
MA
Mammie
10 months ago
It's definitely entity integrity that's violated.
MI
Millie
10 months ago
Totally agree, primary keys can't be null!
TR
Troy
11 months ago
Yup, entity integrity is the right answer.
TH
Thea
11 months ago
I feel like I've seen a question similar to this, and it was definitely about entity integrity being violated with null primary keys.
ST
Stephen
11 months ago
I'm a bit confused; I thought domain integrity was related to the values in the columns, not the primary key itself.
TO
Tom
11 months ago
I remember practicing a question about primary keys and integrity constraints, and I think entity integrity was the right answer there too.
LE
Leigha
11 months ago
I think it's entity integrity that gets violated when a primary key has a null value, but I'm not entirely sure.
JE
Jerilyn
12 months ago
This is a classic database design question. A null primary key definitely violates entity integrity, since the primary key is supposed to uniquely identify each record. I'm confident that's the right answer here.
RE
Reita
12 months ago
I'm a little confused on the differences between the different types of relational integrity. I'll have to review my notes to make sure I understand which one applies to a null primary key.
AN
Annmarie
12 months ago
Okay, let me think this through. If a primary key has a null value, that means there's no unique identifier for that record, which would violate the entity integrity constraints. I'm pretty sure that's the right answer.
RE
Rebecka
1 year ago
Hmm, I'm not totally sure about this one. I know primary keys are important for maintaining data integrity, but I'm not confident which specific type of integrity is violated by a null primary key.
LE
Leonida
1 year ago
This one seems straightforward - a primary key should never be null, so the answer must be entity integrity.
VO
Vonda
1 year ago
I disagree, I believe it's D) Referential integrity.
MA
Maile
1 year ago
A null primary key? That's like trying to find Bigfoot with a blindfold on!
NO
Norah
1 year ago
A null primary key violates entity integrity.
GI
Gianna
1 year ago
I think it's A) Entity integrity.