,WGU C175/D426 Data Management Foundations
Objective Assessment (OA) Exam | 2026/2027 Edition
(PDF)
**1. Which of the following best defines a database?**
A) A collection of unstructured files stored in a single folder
B) A shared, integrated computer structure that stores end-user data and metadata
C) A program that only stores images and videos
D) A spreadsheet with formulas and macros
**Correct Answer:** B) A shared, integrated computer structure that stores end-user data and
metadata
**Rationale:** A database is a shared, integrated computer structure that houses both end-user data
(raw facts) and metadata (data about the data). This structure allows for efficient storage, retrieval, and
management of information, unlike simple spreadsheets or unstructured files.
**2. What is data?**
A) Processed information with meaning
B) Raw facts that have not been processed to reveal their meaning
C) A collection of related tables
D) A structured query language command
**Correct Answer:** B) Raw facts that have not been processed to reveal their meaning
**Rationale:** Data consists of raw, unprocessed facts. When these facts are processed, organized, and
given context, they become information. This distinction is fundamental to understanding database
management.
**3. The three levels of database design are:**
A) Internal, External, and User
,B) Conceptual, Logical, and Physical
C) Relational, Hierarchical, and Network
D) Primary, Secondary, and Tertiary
**Correct Answer:** B) Conceptual, Logical, and Physical
**Rationale:** Database design is structured across three levels: Conceptual (system-independent
requirements), Logical (the logical structure of the data), and Physical (how data is physically stored).
These levels provide abstraction and data independence.
**4. Which design type specifies database requirements without regard to a specific database system?
**
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
**Correct Answer:** B) Conceptual design
**Rationale:** Conceptual design defines the database requirements at a high level without considering
any specific DBMS or physical implementation details. It focuses on identifying entities, attributes, and
relationships.
**5. Which requirement within large, complex databases ensures users have limited access to the
database?**
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
**Correct Answer:** C) Authorization
, **Rationale:** Authorization ensures that only authenticated users have the appropriate permissions to
access, modify, or delete data. It is a critical security mechanism that controls user access based on their
roles and privileges.
**6. Which characteristic distinguishes a DBMS from a simple file system?**
A) Data redundancy is maximized
B) Data isolation is ensured
C) Data consistency and integrity constraints are enforced
D) No concurrent access is allowed
**Correct Answer:** C) Data consistency and integrity constraints are enforced
**Rationale:** A Database Management System (DBMS) enforces data consistency and integrity
through constraints (e.g., primary keys, foreign keys, unique constraints). Simple file systems lack these
features, leading to data anomalies and inconsistencies.
**7. What is a database schema?**
A) The actual data in the database
B) The logical structure or description of the database
C) A backup file
D) A user password
**Correct Answer:** B) The logical structure or description of the database
**Rationale:** A schema is the logical description of the database structure, including the definitions of
tables, columns, relationships, and constraints. It acts as a blueprint for the database.
**8. What is an instance of a database?**
A) The schema only
Objective Assessment (OA) Exam | 2026/2027 Edition
(PDF)
**1. Which of the following best defines a database?**
A) A collection of unstructured files stored in a single folder
B) A shared, integrated computer structure that stores end-user data and metadata
C) A program that only stores images and videos
D) A spreadsheet with formulas and macros
**Correct Answer:** B) A shared, integrated computer structure that stores end-user data and
metadata
**Rationale:** A database is a shared, integrated computer structure that houses both end-user data
(raw facts) and metadata (data about the data). This structure allows for efficient storage, retrieval, and
management of information, unlike simple spreadsheets or unstructured files.
**2. What is data?**
A) Processed information with meaning
B) Raw facts that have not been processed to reveal their meaning
C) A collection of related tables
D) A structured query language command
**Correct Answer:** B) Raw facts that have not been processed to reveal their meaning
**Rationale:** Data consists of raw, unprocessed facts. When these facts are processed, organized, and
given context, they become information. This distinction is fundamental to understanding database
management.
**3. The three levels of database design are:**
A) Internal, External, and User
,B) Conceptual, Logical, and Physical
C) Relational, Hierarchical, and Network
D) Primary, Secondary, and Tertiary
**Correct Answer:** B) Conceptual, Logical, and Physical
**Rationale:** Database design is structured across three levels: Conceptual (system-independent
requirements), Logical (the logical structure of the data), and Physical (how data is physically stored).
These levels provide abstraction and data independence.
**4. Which design type specifies database requirements without regard to a specific database system?
**
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
**Correct Answer:** B) Conceptual design
**Rationale:** Conceptual design defines the database requirements at a high level without considering
any specific DBMS or physical implementation details. It focuses on identifying entities, attributes, and
relationships.
**5. Which requirement within large, complex databases ensures users have limited access to the
database?**
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
**Correct Answer:** C) Authorization
, **Rationale:** Authorization ensures that only authenticated users have the appropriate permissions to
access, modify, or delete data. It is a critical security mechanism that controls user access based on their
roles and privileges.
**6. Which characteristic distinguishes a DBMS from a simple file system?**
A) Data redundancy is maximized
B) Data isolation is ensured
C) Data consistency and integrity constraints are enforced
D) No concurrent access is allowed
**Correct Answer:** C) Data consistency and integrity constraints are enforced
**Rationale:** A Database Management System (DBMS) enforces data consistency and integrity
through constraints (e.g., primary keys, foreign keys, unique constraints). Simple file systems lack these
features, leading to data anomalies and inconsistencies.
**7. What is a database schema?**
A) The actual data in the database
B) The logical structure or description of the database
C) A backup file
D) A user password
**Correct Answer:** B) The logical structure or description of the database
**Rationale:** A schema is the logical description of the database structure, including the definitions of
tables, columns, relationships, and constraints. It acts as a blueprint for the database.
**8. What is an instance of a database?**
A) The schema only
