,WGU D426 OA Exam | Data Management Foundations (2026)
Q&A | Western Governors University
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: 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: 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: 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: 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: 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: 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). A simple
file system does not provide these mechanisms, leading to potential data anomalies.
7. Which term describes numeric, textual, visual, or audio information that describes real-
world systems?
A) Database
B) Metadata
C) Data
Q&A | Western Governors University
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: 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: 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: 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: 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: 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: 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). A simple
file system does not provide these mechanisms, leading to potential data anomalies.
7. Which term describes numeric, textual, visual, or audio information that describes real-
world systems?
A) Database
B) Metadata
C) Data
