What is data integrity in the context of a database?

The number of users that can access the database simultaneously

The accuracy, consistency, and reliability of data stored in the database

The speed at which data can be retrieved from the database

The amount of storage space used by the database

Which statement best describes the primary purpose of a database?

To provide a user interface for creating documents and spreadsheets

To secure a computer network from unauthorized access

To store and manage data in a structured way that allows efficient retrieval, update, and deletion

To compile and execute program code written in a programming language

Which of the following is a common method used to maintain data integrity in a database?

Using a faster network connection

Using constraints such as primary keys and foreign keys

Increasing the database buffer size

Adding more indexes to the tables

A database administrator wants to ensure that only authorized users can access the database and that each user can only perform actions they are permitted to do. Which security measure should be implemented?

User authentication and role-based access control (RBAC)

CompTIATech+

Domain 5Objective 3

Database Use FC0-U71 Practice Questions (Page 3)

Part of the Data and database fundamentals domain, which accounts for 13% of the FC0-U71 exam. CompTIA does not publish an official question count, but from its 60-minute exam (~25–40 total, ~3–5 in this domain), expect 1–1 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

10concepts

13%of the exam

Questions 11–15

11foundation · easy
What is data integrity in the context of a database?
Select an answer first
12foundation · easy
Which statement best describes the primary purpose of a database?
Select an answer first
13application · medium
A manager wants to see the total sales amount for each product category, but only for categories with total sales over $10,000. Which SQL clause should be used to filter the grouped results?
Select an answer first
14foundation · easy
Which of the following is a common method used to maintain data integrity in a database?
Select an answer first
15application · medium
A database administrator wants to ensure that only authorized users can access the database and that each user can only perform actions they are permitted to do. Which security measure should be implemented?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to FC0-U71

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “FC0-U71” is a trademark of its owner, used for identification only.