FC0-U71 Applications and Software Practice Question
A user is evaluating database concepts while building a small inventory system. Which TWO statements accurately describe a relational database? (Choose two.)
⚠ Common exam trap
The trap here is treating any collection of data as relational, when the defining traits are table structure plus key-based relationships.
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 organized into tables with rows and columns.
A relational database organizes data into tables of rows and columns and links those tables through primary and foreign keys. Those two properties define the model. Storing each table on separate hardware, using unlabeled flat files, or requiring JavaScript for queries are all inconsistent with how relational databases actually work.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Each table must be stored on a separate physical server.
Why it's wrong here
Relational database tables commonly reside in a single database on one server, and a database can contain many tables. Distributing each table to its own server is neither required nor typical. This statement misrepresents how relational databases are deployed and would make the small inventory system unnecessarily complex.
- ✗
Records are stored as unlabeled values in a single flat file.
Why it's wrong here
That description fits a flat-file or delimited-text approach, not a relational database. Relational tables have named columns and defined data types, and they support relationships between tables. Storing unlabeled values in one file would remove the structure and integrity that the relational model provides, so this statement is incorrect.
- ✓
Data is organized into tables with rows and columns.
Why this is correct
Relational databases store data in relations, commonly called tables, where rows represent records and columns represent fields. This is the defining structural characteristic of the relational model. The inventory system would place products in one table and suppliers in another, so this statement correctly describes the concept.
- ✓
Tables are linked through primary and foreign key relationships.
Why this is correct
Primary keys uniquely identify each row, and foreign keys reference primary keys in other tables to enforce referential integrity. This linkage is what makes the model relational and allows joins across tables. For an inventory system, an order table can reference a product table this way, so the statement is accurate.
- ✗
Queries are written only in JavaScript.
Why it's wrong here
Relational databases are queried primarily with Structured Query Language (SQL), not JavaScript. JavaScript may be used in an application layer that calls the database, but it is not the query language of the relational model. This statement confuses a client-side scripting language with the standard database query language.
Go deeper
Related to this question
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.