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?
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
One customer can have many orders, but each order belongs to one customer, which is a one-to-many relationship.
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
Orders are linked to customers via a foreign key, so a relationship exists.
- ✓
One-to-many
Why this is correct
Each customer can have multiple orders, but each order links to one customer.
- ✗
Many-to-many
Why it's wrong here
Many-to-many would require a junction table, e.g., if multiple customers could share an order.
- ✗
One-to-one
Why it's wrong here
One-to-one would mean each customer has only one order, which is not typical.
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.