Courseiva
← FC0-U71
Full test
hardMultiple SelectObjective-mapped

FC0-U71 Practice Question: Which THREE of the following are characteristics…

Which THREE of the following are characteristics of a relational database?

⚠ Common exam trap

Many candidates confuse the flexible, schema-less nature of NoSQL databases with the rigid, table-based structure of relational databases, leading them to incorrectly select Option A or D.

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

✓

Data is stored in tables with rows and columns

A relational database organizes data into tables, where each table consists of rows (records) and columns (attributes). This tabular structure enforces a fixed schema and allows relationships between tables to be defined and queried efficiently. Option B correctly identifies this fundamental characteristic.

Answer analysis

Option-by-option breakdown

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

  • ✗

    Schema-less design allows flexible data structures

    Why it's wrong here

    Relational databases have a fixed schema.

  • ✓

    Data is stored in tables with rows and columns

    Why this is correct

    Tables are the fundamental structure.

  • ✓

    Uses Structured Query Language (SQL) for queries

    Why this is correct

    SQL is the standard query language.

  • ✗

    Uses a document-based model like JSON

    Why it's wrong here

    Document-based is NoSQL, not relational.

  • ✓

    Enforces referential integrity through foreign keys

    Why this is correct

    Foreign keys maintain relationships between tables.

About these practice questions

This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.