FC0-U71 Data and Database Fundamentals Practice Question
A company uses a relational database with a 'Customers' table and an 'Orders' table. Each order must be linked to exactly one customer. Which type of relationship exists between Customers and Orders?
⚠ Common exam trap
The trap is misinterpreting the cardinality: candidates might think one-to-one because each order has one customer, but they forget that a customer can have many orders, making it one-to-many.
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
✓
One-to-many
In a relational database, if each order must be linked to exactly one customer, but a customer can have multiple orders, the relationship is one-to-many. The 'one' side is Customers (each customer is unique) and the 'many' side is Orders (multiple orders per customer). This is implemented via a foreign key in the Orders table referencing the primary key in Customers.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
No relationship
Why it's wrong here
A foreign key linking each order to a customer establishes a relationship, so none cannot exist here. No relationship would apply only if the two tables were entirely independent, with no shared key or referential constraint between their records.
- ✓
One-to-many
Why this is correct
One-to-many fits because a single customer row can be referenced by many order rows, while each order holds exactly one foreign key back to its customer. This satisfies the stem's constraint that every order links to precisely one customer, with no order shared between customers.
- ✗
Many-to-many
Why it's wrong here
Many-to-many requires a junction table because each order links to exactly one customer, a single foreign key, not multiple customers per order. Many-to-many fits scenarios such as students enrolling in multiple courses, where neither side holds a single reference.
- ✗
One-to-one
Why it's wrong here
One-to-one would require each customer to link to at most one order, but the stem allows a customer to have many orders while each order references exactly one customer. One-to-one applies when both sides hold a single record, such as a person and their passport.
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 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.