Courseiva
← FC0-U71
Full test
easyMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: A database table contains repeating groups of…

A database table contains repeating groups of fields for multiple phone numbers per customer. Which normal form is being violated?

⚠ Common exam trap

CompTIA often tests the misconception that repeating groups are a violation of Second or Third Normal Form, but the trap is that repeating groups are the defining characteristic of a First Normal Form violation, not a higher normal form.

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

✓

First Normal Form

First Normal Form (1NF) requires that each column in a table contains atomic (indivisible) values and that there are no repeating groups of columns. Storing multiple phone numbers per customer in a single row, such as Phone1, Phone2, Phone3, violates 1NF because it creates a repeating group of fields. To comply with 1NF, the phone numbers should be stored in a separate child table with one row per phone number per customer.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Second Normal Form

    Why it's wrong here

    This violation is about repeating groups, not partial dependencies.

  • ✗

    Third Normal Form

    Why it's wrong here

    Transitive dependencies are not the issue here.

  • ✓

    First Normal Form

    Why this is correct

    Repeating groups violate 1NF.

  • ✗

    No violation

    Why it's wrong here

    Repeating groups are a clear violation of 1NF.

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 →

How Courseiva writes practice questions · Editorial policy

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.