WGU D446 Data Management –
Foundations exam with questions and
verified answers with rationale
Section 1: Database Fundamentals (1–10)
1. What is the primary purpose of a Database Management System (DBMS)?
A. To create web applications
B. To manage hardware resources
C. To provide an organized way to store, manage, and retrieve data
D. To replace all file systems entirely
Rationale: A DBMS serves as an intermediary between users/applications and the physical database,
enabling efficient storage, manipulation, retrieval, and enforcement of integrity and security rules.
2. Which term describes raw facts, figures, and symbols before they are processed?
A. Information
B. Data
C. Knowledge
D. Metadata
Rationale: Data consists of unprocessed raw facts. When data is processed and given context, it
becomes information.
3. What is a major disadvantage of file‑system data management compared to a database approach?
A. It is too expensive for small businesses
B. Data redundancy and inconsistency are common
C. It requires an internet connection
D. It only supports text files
,Rationale: Traditional file systems often store duplicate data in separate files, leading to redundancy
and potential inconsistency when updates are not propagated everywhere.
4. Which level of database abstraction describes how data is physically stored on hardware?
A. External level
B. Conceptual level
C. Internal level
D. Logical level
Rationale: The internal (physical) level of the ANSI‑SPARC architecture deals with physical storage
structures, indexes, and file organization.
5. Logical data independence refers to the capacity to change which schema without affecting
application programs?
A. Internal schema
B. Conceptual schema
C. External schema
D. Physical schema
Rationale: Logical data independence allows changes to the conceptual (logical) schema—such as
adding a table—without requiring changes to external schemas or application programs.
6. What does physical data independence allow?
A. Changes to user views without affecting the conceptual schema
B. Changes to the physical storage without affecting the conceptual schema
C. Changes to the DBMS vendor without migrating data
D. Changes to business rules without altering data
Rationale: Physical data independence insulates the conceptual schema from changes in physical
storage details like file organization or indexing.
7. Which data model uses tree‑like structures with parent‑child relationships?
,A. Hierarchical model
B. Relational model
C. Network model
D. Object‑oriented model
Rationale: The hierarchical model organizes data in a tree structure where each child has exactly one
parent, creating one‑to‑many relationships.
8. In the relational model, what is a relation?
A. A connection between two databases
B. A two‑dimensional table consisting of rows and columns
C. A foreign key constraint
D. A type of SQL query
Rationale: In relational terminology, a relation is a table, a tuple is a row, and an attribute is a
column.
9. Who is typically responsible for designing the database schema and enforcing security standards?
A. End user
B. Application developer
C. Database Administrator (DBA)
D. Network engineer
Rationale: The DBA is responsible for the overall management, design, security, and performance of
the database system.
10. What is metadata?
A. Data that has been encrypted
B. Data about data
C. Data that is no longer used
D. Data stored in a data warehouse only
, Rationale: Metadata describes the structure, constraints, and properties of data, such as table
definitions, data types, and access permissions.
Section 2: Relational Model & Keys (11–20)
11. Which key attribute uniquely identifies each row in a table and cannot contain null values?
A. Foreign key
B. Candidate key
C. Alternate key
D. Primary key
Rationale: A primary key is a minimal set of attributes that uniquely identifies each tuple in a relation
and enforces entity integrity by disallowing nulls.
12. A key that uniquely identifies rows but is not chosen as the primary key is called:
A. Composite key
B. Alternate key
C. Foreign key
D. Superkey
Rationale: A candidate key not selected as the primary key becomes an alternate key; it still
maintains uniqueness but is not the main identifier.
13. What is the purpose of a foreign key?
A. To uniquely identify rows in its own table
B. To establish a link between two tables by referencing a primary key
C. To automatically index a table
D. To encrypt sensitive column values
Rationale: A foreign key in one table points to a primary key in another (or the same) table to
enforce referential integrity between relations.
14. Referential integrity ensures that:
Foundations exam with questions and
verified answers with rationale
Section 1: Database Fundamentals (1–10)
1. What is the primary purpose of a Database Management System (DBMS)?
A. To create web applications
B. To manage hardware resources
C. To provide an organized way to store, manage, and retrieve data
D. To replace all file systems entirely
Rationale: A DBMS serves as an intermediary between users/applications and the physical database,
enabling efficient storage, manipulation, retrieval, and enforcement of integrity and security rules.
2. Which term describes raw facts, figures, and symbols before they are processed?
A. Information
B. Data
C. Knowledge
D. Metadata
Rationale: Data consists of unprocessed raw facts. When data is processed and given context, it
becomes information.
3. What is a major disadvantage of file‑system data management compared to a database approach?
A. It is too expensive for small businesses
B. Data redundancy and inconsistency are common
C. It requires an internet connection
D. It only supports text files
,Rationale: Traditional file systems often store duplicate data in separate files, leading to redundancy
and potential inconsistency when updates are not propagated everywhere.
4. Which level of database abstraction describes how data is physically stored on hardware?
A. External level
B. Conceptual level
C. Internal level
D. Logical level
Rationale: The internal (physical) level of the ANSI‑SPARC architecture deals with physical storage
structures, indexes, and file organization.
5. Logical data independence refers to the capacity to change which schema without affecting
application programs?
A. Internal schema
B. Conceptual schema
C. External schema
D. Physical schema
Rationale: Logical data independence allows changes to the conceptual (logical) schema—such as
adding a table—without requiring changes to external schemas or application programs.
6. What does physical data independence allow?
A. Changes to user views without affecting the conceptual schema
B. Changes to the physical storage without affecting the conceptual schema
C. Changes to the DBMS vendor without migrating data
D. Changes to business rules without altering data
Rationale: Physical data independence insulates the conceptual schema from changes in physical
storage details like file organization or indexing.
7. Which data model uses tree‑like structures with parent‑child relationships?
,A. Hierarchical model
B. Relational model
C. Network model
D. Object‑oriented model
Rationale: The hierarchical model organizes data in a tree structure where each child has exactly one
parent, creating one‑to‑many relationships.
8. In the relational model, what is a relation?
A. A connection between two databases
B. A two‑dimensional table consisting of rows and columns
C. A foreign key constraint
D. A type of SQL query
Rationale: In relational terminology, a relation is a table, a tuple is a row, and an attribute is a
column.
9. Who is typically responsible for designing the database schema and enforcing security standards?
A. End user
B. Application developer
C. Database Administrator (DBA)
D. Network engineer
Rationale: The DBA is responsible for the overall management, design, security, and performance of
the database system.
10. What is metadata?
A. Data that has been encrypted
B. Data about data
C. Data that is no longer used
D. Data stored in a data warehouse only
, Rationale: Metadata describes the structure, constraints, and properties of data, such as table
definitions, data types, and access permissions.
Section 2: Relational Model & Keys (11–20)
11. Which key attribute uniquely identifies each row in a table and cannot contain null values?
A. Foreign key
B. Candidate key
C. Alternate key
D. Primary key
Rationale: A primary key is a minimal set of attributes that uniquely identifies each tuple in a relation
and enforces entity integrity by disallowing nulls.
12. A key that uniquely identifies rows but is not chosen as the primary key is called:
A. Composite key
B. Alternate key
C. Foreign key
D. Superkey
Rationale: A candidate key not selected as the primary key becomes an alternate key; it still
maintains uniqueness but is not the main identifier.
13. What is the purpose of a foreign key?
A. To uniquely identify rows in its own table
B. To establish a link between two tables by referencing a primary key
C. To automatically index a table
D. To encrypt sensitive column values
Rationale: A foreign key in one table points to a primary key in another (or the same) table to
enforce referential integrity between relations.
14. Referential integrity ensures that:
