WGU D195 Data Management Foundations Practice Questions and
Answers Updated 2026 | Complete WGU Database Management Study
Guide with Verified Questions, Detailed Rationales, Relational Databases,
SQL Queries, Data Modeling, Database Design, Normalization, Data
Integrity, Entity Relationship Diagrams (ERD), Database Security &
Objective Assessment Exam Prep
Question 1: Which of the following best defines a primary key in a relational
database?
A. A field that allows duplicate values to be stored for efficient searching
B. A field or combination of fields that uniquely identifies each record in a table
C. A field that references a primary key in another table to establish a relationship
D. A field that stores encrypted data to enhance security
CORRECT ANSWER: B. A field or combination of fields that uniquely identifies each
record in a table
Rationale: A primary key is a fundamental constraint in relational database design that
ensures entity integrity by uniquely identifying each row in a table. It cannot contain
NULL values and must contain unique values for every record, making it essential for
establishing relationships and maintaining data consistency.
Question 2: In the context of data modeling, what does the term "cardinality" refer
to?
A. The number of attributes in an entity
B. The numerical relationship between entities in a relationship
C. The size of the database in gigabytes
D. The speed at which queries are executed
CORRECT ANSWER: B. The numerical relationship between entities in a
relationship
Rationale: Cardinality in data modeling describes the numerical relationship between
instances of one entity and instances of another entity in a relationship. Common
cardinalities include one-to-one, one-to-many, and many-to-many, which are critical for
designing accurate relational schemas and foreign key constraints.
Question 3: Which SQL clause is used to filter records after a GROUP BY operation
has been applied?
A. WHERE
B. FILTER
C. HAVING
D. ORDER BY
CORRECT ANSWER: C. HAVING
,Rationale: The HAVING clause is specifically designed to filter groups of rows after
aggregation functions have been applied with GROUP BY. Unlike the WHERE clause,
which filters individual rows before grouping, HAVING operates on aggregated results,
making it essential for conditional filtering of summary data.
Question 4: What is the primary purpose of database normalization?
A. To increase data redundancy for faster query performance
B. To reduce data redundancy and improve data integrity
C. To encrypt sensitive data fields automatically
D. To create backup copies of database tables
CORRECT ANSWER: B. To reduce data redundancy and improve data integrity
Rationale: Normalization is a systematic process of organizing data in a database to
minimize redundancy and dependency. By decomposing tables and establishing proper
relationships, normalization reduces update anomalies, insertion anomalies, and
deletion anomalies, thereby enhancing data integrity and consistency.
Question 5: Which of the following ACID properties ensures that a transaction is
either fully completed or not executed at all?
A. Consistency
B. Isolation
C. Durability
D. Atomicity
CORRECT ANSWER: D. Atomicity
Rationale: Atomicity, one of the four ACID (Atomicity, Consistency, Isolation, Durability)
properties, guarantees that database transactions are treated as indivisible units. If any
part of a transaction fails, the entire transaction is rolled back, ensuring that the
database remains in a consistent state without partial updates.
Question 6: In an Entity-Relationship (ER) diagram, what does a rectangle symbol
typically represent?
A. A relationship between entities
B. An attribute of an entity
C. An entity or table
D. A primary key constraint
CORRECT ANSWER: C. An entity or table
Rationale: In standard ER diagram notation, rectangles represent entities, which
correspond to tables in a relational database. Diamonds represent relationships, ovals
represent attributes, and lines connect these elements to illustrate the structure and
associations within the data model.
Question 7: Which SQL statement is used to modify existing data in a table?
,A. MODIFY
B. CHANGE
C. UPDATE
D. ALTER
CORRECT ANSWER: C. UPDATE
Rationale: The UPDATE statement is the standard SQL command for modifying existing
records in a table. It is used with a SET clause to specify new values and typically
includes a WHERE clause to target specific rows, ensuring precise data modifications
without affecting unintended records.
Question 8: What is the main function of a foreign key constraint?
A. To uniquely identify each row within its own table
B. To enforce referential integrity between two related tables
C. To automatically generate sequential values for a column
D. To encrypt data stored in a specific column
CORRECT ANSWER: B. To enforce referential integrity between two related tables
Rationale: A foreign key constraint establishes a link between data in two tables by
referencing the primary key of another table. This enforces referential integrity, ensuring
that relationships between tables remain valid and preventing orphaned records or
inconsistent data references.
Question 9: Which normal form eliminates transitive dependencies where a non-
key attribute depends on another non-key attribute?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
CORRECT ANSWER: C. Third Normal Form (3NF)
Rationale: Third Normal Form requires that a table be in 2NF and that all non-key
attributes are functionally dependent only on the primary key, not on other non-key
attributes. This eliminates transitive dependencies, reducing redundancy and
preventing update anomalies in database design.
Question 10: Which of the following best describes a "data dictionary" in database
management?
A. A tool for translating SQL queries into natural language
B. A repository that stores metadata about database objects and their definitions
C. A backup file containing copies of all database records
D. A user interface for entering data into database tables
, CORRECT ANSWER: B. A repository that stores metadata about database objects
and their definitions
Rationale: A data dictionary is a centralized repository of metadata that documents
database structures, including table names, column definitions, data types,
constraints, and relationships. It serves as a critical reference for database
administrators, developers, and analysts to understand and maintain the database
schema.
Question 11: What does the SQL JOIN clause primarily accomplish?
A. Combines rows from two or more tables based on a related column
B. Deletes duplicate records from a single table
C. Creates a new table by copying data from an existing table
D. Encrypts data during transmission between client and server
CORRECT ANSWER: A. Combines rows from two or more tables based on a related
column
Rationale: The JOIN clause in SQL is used to combine rows from multiple tables based
on a related column, typically a foreign key relationship. Different JOIN types (INNER,
LEFT, RIGHT, FULL) determine which rows are included in the result set, enabling
complex queries across normalized database structures.
Question 12: Which data type is most appropriate for storing a person's date of
birth in a relational database?
A. VARCHAR
B. INTEGER
C. DATE
D. BOOLEAN
CORRECT ANSWER: C. DATE
Rationale: The DATE data type is specifically designed to store calendar dates, providing
built-in functions for date arithmetic, formatting, and validation. Using DATE for
birthdates ensures data integrity, enables efficient date-based queries, and avoids
errors associated with storing dates as text or numeric values.
Question 13: In database security, what is the principle of "least privilege"?
A. Granting all users full administrative access to simplify management
B. Providing users only the minimum permissions necessary to perform their tasks
C. Requiring all database queries to be logged for audit purposes
D. Encrypting all data at rest and in transit by default
CORRECT ANSWER: B. Providing users only the minimum permissions necessary to
perform their tasks
Answers Updated 2026 | Complete WGU Database Management Study
Guide with Verified Questions, Detailed Rationales, Relational Databases,
SQL Queries, Data Modeling, Database Design, Normalization, Data
Integrity, Entity Relationship Diagrams (ERD), Database Security &
Objective Assessment Exam Prep
Question 1: Which of the following best defines a primary key in a relational
database?
A. A field that allows duplicate values to be stored for efficient searching
B. A field or combination of fields that uniquely identifies each record in a table
C. A field that references a primary key in another table to establish a relationship
D. A field that stores encrypted data to enhance security
CORRECT ANSWER: B. A field or combination of fields that uniquely identifies each
record in a table
Rationale: A primary key is a fundamental constraint in relational database design that
ensures entity integrity by uniquely identifying each row in a table. It cannot contain
NULL values and must contain unique values for every record, making it essential for
establishing relationships and maintaining data consistency.
Question 2: In the context of data modeling, what does the term "cardinality" refer
to?
A. The number of attributes in an entity
B. The numerical relationship between entities in a relationship
C. The size of the database in gigabytes
D. The speed at which queries are executed
CORRECT ANSWER: B. The numerical relationship between entities in a
relationship
Rationale: Cardinality in data modeling describes the numerical relationship between
instances of one entity and instances of another entity in a relationship. Common
cardinalities include one-to-one, one-to-many, and many-to-many, which are critical for
designing accurate relational schemas and foreign key constraints.
Question 3: Which SQL clause is used to filter records after a GROUP BY operation
has been applied?
A. WHERE
B. FILTER
C. HAVING
D. ORDER BY
CORRECT ANSWER: C. HAVING
,Rationale: The HAVING clause is specifically designed to filter groups of rows after
aggregation functions have been applied with GROUP BY. Unlike the WHERE clause,
which filters individual rows before grouping, HAVING operates on aggregated results,
making it essential for conditional filtering of summary data.
Question 4: What is the primary purpose of database normalization?
A. To increase data redundancy for faster query performance
B. To reduce data redundancy and improve data integrity
C. To encrypt sensitive data fields automatically
D. To create backup copies of database tables
CORRECT ANSWER: B. To reduce data redundancy and improve data integrity
Rationale: Normalization is a systematic process of organizing data in a database to
minimize redundancy and dependency. By decomposing tables and establishing proper
relationships, normalization reduces update anomalies, insertion anomalies, and
deletion anomalies, thereby enhancing data integrity and consistency.
Question 5: Which of the following ACID properties ensures that a transaction is
either fully completed or not executed at all?
A. Consistency
B. Isolation
C. Durability
D. Atomicity
CORRECT ANSWER: D. Atomicity
Rationale: Atomicity, one of the four ACID (Atomicity, Consistency, Isolation, Durability)
properties, guarantees that database transactions are treated as indivisible units. If any
part of a transaction fails, the entire transaction is rolled back, ensuring that the
database remains in a consistent state without partial updates.
Question 6: In an Entity-Relationship (ER) diagram, what does a rectangle symbol
typically represent?
A. A relationship between entities
B. An attribute of an entity
C. An entity or table
D. A primary key constraint
CORRECT ANSWER: C. An entity or table
Rationale: In standard ER diagram notation, rectangles represent entities, which
correspond to tables in a relational database. Diamonds represent relationships, ovals
represent attributes, and lines connect these elements to illustrate the structure and
associations within the data model.
Question 7: Which SQL statement is used to modify existing data in a table?
,A. MODIFY
B. CHANGE
C. UPDATE
D. ALTER
CORRECT ANSWER: C. UPDATE
Rationale: The UPDATE statement is the standard SQL command for modifying existing
records in a table. It is used with a SET clause to specify new values and typically
includes a WHERE clause to target specific rows, ensuring precise data modifications
without affecting unintended records.
Question 8: What is the main function of a foreign key constraint?
A. To uniquely identify each row within its own table
B. To enforce referential integrity between two related tables
C. To automatically generate sequential values for a column
D. To encrypt data stored in a specific column
CORRECT ANSWER: B. To enforce referential integrity between two related tables
Rationale: A foreign key constraint establishes a link between data in two tables by
referencing the primary key of another table. This enforces referential integrity, ensuring
that relationships between tables remain valid and preventing orphaned records or
inconsistent data references.
Question 9: Which normal form eliminates transitive dependencies where a non-
key attribute depends on another non-key attribute?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
CORRECT ANSWER: C. Third Normal Form (3NF)
Rationale: Third Normal Form requires that a table be in 2NF and that all non-key
attributes are functionally dependent only on the primary key, not on other non-key
attributes. This eliminates transitive dependencies, reducing redundancy and
preventing update anomalies in database design.
Question 10: Which of the following best describes a "data dictionary" in database
management?
A. A tool for translating SQL queries into natural language
B. A repository that stores metadata about database objects and their definitions
C. A backup file containing copies of all database records
D. A user interface for entering data into database tables
, CORRECT ANSWER: B. A repository that stores metadata about database objects
and their definitions
Rationale: A data dictionary is a centralized repository of metadata that documents
database structures, including table names, column definitions, data types,
constraints, and relationships. It serves as a critical reference for database
administrators, developers, and analysts to understand and maintain the database
schema.
Question 11: What does the SQL JOIN clause primarily accomplish?
A. Combines rows from two or more tables based on a related column
B. Deletes duplicate records from a single table
C. Creates a new table by copying data from an existing table
D. Encrypts data during transmission between client and server
CORRECT ANSWER: A. Combines rows from two or more tables based on a related
column
Rationale: The JOIN clause in SQL is used to combine rows from multiple tables based
on a related column, typically a foreign key relationship. Different JOIN types (INNER,
LEFT, RIGHT, FULL) determine which rows are included in the result set, enabling
complex queries across normalized database structures.
Question 12: Which data type is most appropriate for storing a person's date of
birth in a relational database?
A. VARCHAR
B. INTEGER
C. DATE
D. BOOLEAN
CORRECT ANSWER: C. DATE
Rationale: The DATE data type is specifically designed to store calendar dates, providing
built-in functions for date arithmetic, formatting, and validation. Using DATE for
birthdates ensures data integrity, enables efficient date-based queries, and avoids
errors associated with storing dates as text or numeric values.
Question 13: In database security, what is the principle of "least privilege"?
A. Granting all users full administrative access to simplify management
B. Providing users only the minimum permissions necessary to perform their tasks
C. Requiring all database queries to be logged for audit purposes
D. Encrypting all data at rest and in transit by default
CORRECT ANSWER: B. Providing users only the minimum permissions necessary to
perform their tasks
