hardMultiple SelectObjective-mapped
FC0-U71 Practice Question: Which THREE of the following are valid database…
Which THREE of the following are valid database integrity constraints?
⚠ Common exam trap
Many candidates confuse database objects like indexes with integrity constraints, or they invent terms like 'CONDITION' because it sounds similar to the valid CHECK constraint, leading them to select incorrect options.
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
✓
UNIQUE
A UNIQUE constraint ensures that all values in a column or a set of columns are distinct from one another, preventing duplicate entries. This is a standard SQL integrity constraint that enforces data uniqueness at the table level, and it is correctly listed as a valid database integrity constraint.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
UNIQUE
Why this is correct
Ensures all values in a column are distinct.
- ✗
INDEX
Why it's wrong here
Indexes are not constraints; they improve query performance.
- ✓
FOREIGN KEY
Why this is correct
Ensures referential integrity between tables.
- ✗
CONDITION
Why it's wrong here
This is not a standard SQL constraint name; the correct term is CHECK.
- ✓
PRIMARY KEY
Why this is correct
Ensures uniqueness and non-null for a column or set of columns.
Go deeper
Related to this question
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.