FC0-U71 Data and Database Fundamentals Practice Question
Which THREE of the following are types of data integrity enforced in relational databases?
⚠ Common exam trap
The trap is including non-standard terms like 'network integrity' or 'file integrity' that sound plausible but are not part of the classic relational database integrity types.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Referential integrity
Referential integrity (A) is a relational-database constraint that ensures a foreign key value in one table matches an existing primary key or unique value in the referenced table, preventing orphaned rows. Entity integrity (B) requires that every table have a primary key and that its values be unique and non-null, so each row is uniquely identifiable. Domain integrity (E) restricts a column's values to a defined set of valid data types, formats, ranges, or allowed values, typically enforced with CHECK constraints, data types, and NOT NULL. Network integrity (C) and file integrity (D) are not relational-database integrity types; they concern data transmission and file-level integrity (e.g., checksums), not the relational model's constraint categories.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Referential integrity
Why this is correct
Referential integrity constrains foreign key values to match existing primary keys in the referenced table, preventing orphaned rows. It is one of the three relational integrity types, alongside entity and domain integrity, enforced by the database engine rather than application code.
- ✓
Entity integrity
Why this is correct
Entity integrity requires every table to have a primary key that is unique and non-null, ensuring each row is uniquely identifiable. It is one of the three relational integrity types, alongside referential and domain integrity, enforced directly by the database.
- ✗
Network integrity
Why it's wrong here
Network integrity is not a relational data integrity category; the enforced types are entity, domain, referential and user-defined. It tempts because networks need integrity controls, and in a networking exam this would be a valid concern, but relational integrity governs table relationships and column values, not packet delivery.
- ✗
File integrity
Why it's wrong here
File integrity concerns storage-level checksums and tamper detection, not the relational model's entity, domain, referential and user-defined integrity types. It tempts because databases ultimately persist to files, and file integrity monitoring is a genuine security control, but it operates below the schema constraints this question asks about.
- ✓
Domain integrity
Why this is correct
Domain integrity restricts a column's values to a defined set via data types, CHECK constraints, nullability and defaults, ensuring entries are valid for that attribute. It is one of the three relational integrity types, alongside entity and referential integrity.
Go deeper
Related to this question
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This FC0-U71 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the FC0-U71 exam.