WGU D426 Data Management – Foundations Objective
Assessment (OA) Exam Test Bank | Comprehensive
Practice Exam with Actual Exam Questions, Verified
Correct Answers and Detailed Rationales | Latest Update
2026/2027 – Already Graded A+
Question 1
Which type of primary key consists of a single column and is easier to type, store,
and process than composite keys?
A. Composite Primary Key
B. Simple Primary Key
C. Multi-column Key
D. Multi-primary Key
Answer: B
Rationale: A Simple Primary Key consists of a single column and is easier to type,
store, and process than composite or multi-column keys. Simple keys are more
efficient for query processing and indexing because smaller values are easy to
specify in an SQL WHERE clause and speed up query processing.
Question 2
Which category of SQL statements includes INSERT, SELECT, UPDATE, and
DELETE?
A. DDL Statements
B. SQL Statements
C. MySQL Commands
D. DML Statements
Answer: D
Rationale: INSERT, SELECT, UPDATE, and DELETE are Data Manipulation
Language (DML) statements. DML statements are used to manipulate data stored
in the database, as opposed to DDL which defines the database structure.
pg. 1
,Question 3
What is a group of related entities called?
A. Subject Area
B. Attribute Instance
C. Attribute Type
D. Joint
Answer: A
Rationale: A Subject Area is a group of related entities that represent a specific
domain or area of interest within a database. This helps organize the database into
logical groupings.
Question 4
Which operator divides one numeric value by another and returns the integer
remainder?
A. INNER JOIN
B. % (Modulo)
C. Tablespace
D. NON-EQUIJOIN
Answer: B
Rationale: The modulo operator (%) divides one numeric value by another and
returns the integer remainder. This is commonly used in programming and
database operations for calculations, including hash functions to map keys to
bucket numbers.
Question 5
A ______ is a set of related things that defines how entities are connected to each
other in a database:
A. Primary Key
B. Relationship Type
C. Entity Instance
D. Attribute Domain
Answer: B
Rationale: A Relationship Type is a set of related things that defines how entities
are connected to each other in a database. It describes the association between
entity types.
pg. 2
,Question 6
What are words with special meaning in SQL, such as SELECT, FROM, and
WHERE, called?
A. Application Programming Interface (API)
B. NULL
C. UPDATE Statement (Clauses)
D. Keywords (SQL Syntax)
Answer: D
Rationale: Keywords are words with special meaning in SQL, such as SELECT,
FROM, and WHERE. They are reserved words that are part of the SQL syntax and
cannot be used as table or column names without special handling.
Question 7
What is the intersection of a row and a column in a table called?
A. Attribute
B. Cell
C. Object
D. Database
Answer: B
Rationale: A cell is the intersection of a row and a column in a table, representing
a single value. Each cell contains a specific piece of data at the intersection of a
row and column.
Question 8
Which type of function performs calculations on a set of values and returns a
single value, such as COUNT(), MIN(), MAX(), SUM(), and AVG()?
A. CHECK (Constraint)
B. UNIQUE (Constraint)
C. UNION (Keyword)
D. Aggregate (Function)
Answer: D
Rationale: Aggregate functions perform calculations on a set of values and return
a single value. Common aggregate functions include COUNT, MIN, MAX, SUM,
and AVG. They are often used with GROUP BY clauses.
pg. 3
, Question 9
Which component ensures transactions are properly executed, prevents conflicts
between concurrent transactions, and restores the database to a consistent state in
the event of a transaction or system failure?
A. Load Manager
B. Warehouse Manager
C. Storage Manager
D. Transaction Manager
Answer: D
Rationale: The Transaction Manager ensures transactions are properly executed,
prevents conflicts between concurrent transactions, and restores the database to a
consistent state in the event of failure. It is a key component of ACID compliance.
Question 10
What is documented in the data model but not tracked with data in the database,
representing logical rules and constraints that govern the data but aren't explicitly
stored as data themselves?
A. Tangible Entity
B. Primary Key
C. Intangible Entity
D. Physical Attribute
Answer: C
Rationale: An Intangible Entity is documented in the data model but not tracked
with data in the database. These represent logical rules and constraints that govern
the data but aren't explicitly stored as data themselves.
Question 11
What ensures data is consistent with structural and business rules in a database
system?
A. Laws
B. Functions
C. Definitions
D. Rules
Answer: D
pg. 4
Assessment (OA) Exam Test Bank | Comprehensive
Practice Exam with Actual Exam Questions, Verified
Correct Answers and Detailed Rationales | Latest Update
2026/2027 – Already Graded A+
Question 1
Which type of primary key consists of a single column and is easier to type, store,
and process than composite keys?
A. Composite Primary Key
B. Simple Primary Key
C. Multi-column Key
D. Multi-primary Key
Answer: B
Rationale: A Simple Primary Key consists of a single column and is easier to type,
store, and process than composite or multi-column keys. Simple keys are more
efficient for query processing and indexing because smaller values are easy to
specify in an SQL WHERE clause and speed up query processing.
Question 2
Which category of SQL statements includes INSERT, SELECT, UPDATE, and
DELETE?
A. DDL Statements
B. SQL Statements
C. MySQL Commands
D. DML Statements
Answer: D
Rationale: INSERT, SELECT, UPDATE, and DELETE are Data Manipulation
Language (DML) statements. DML statements are used to manipulate data stored
in the database, as opposed to DDL which defines the database structure.
pg. 1
,Question 3
What is a group of related entities called?
A. Subject Area
B. Attribute Instance
C. Attribute Type
D. Joint
Answer: A
Rationale: A Subject Area is a group of related entities that represent a specific
domain or area of interest within a database. This helps organize the database into
logical groupings.
Question 4
Which operator divides one numeric value by another and returns the integer
remainder?
A. INNER JOIN
B. % (Modulo)
C. Tablespace
D. NON-EQUIJOIN
Answer: B
Rationale: The modulo operator (%) divides one numeric value by another and
returns the integer remainder. This is commonly used in programming and
database operations for calculations, including hash functions to map keys to
bucket numbers.
Question 5
A ______ is a set of related things that defines how entities are connected to each
other in a database:
A. Primary Key
B. Relationship Type
C. Entity Instance
D. Attribute Domain
Answer: B
Rationale: A Relationship Type is a set of related things that defines how entities
are connected to each other in a database. It describes the association between
entity types.
pg. 2
,Question 6
What are words with special meaning in SQL, such as SELECT, FROM, and
WHERE, called?
A. Application Programming Interface (API)
B. NULL
C. UPDATE Statement (Clauses)
D. Keywords (SQL Syntax)
Answer: D
Rationale: Keywords are words with special meaning in SQL, such as SELECT,
FROM, and WHERE. They are reserved words that are part of the SQL syntax and
cannot be used as table or column names without special handling.
Question 7
What is the intersection of a row and a column in a table called?
A. Attribute
B. Cell
C. Object
D. Database
Answer: B
Rationale: A cell is the intersection of a row and a column in a table, representing
a single value. Each cell contains a specific piece of data at the intersection of a
row and column.
Question 8
Which type of function performs calculations on a set of values and returns a
single value, such as COUNT(), MIN(), MAX(), SUM(), and AVG()?
A. CHECK (Constraint)
B. UNIQUE (Constraint)
C. UNION (Keyword)
D. Aggregate (Function)
Answer: D
Rationale: Aggregate functions perform calculations on a set of values and return
a single value. Common aggregate functions include COUNT, MIN, MAX, SUM,
and AVG. They are often used with GROUP BY clauses.
pg. 3
, Question 9
Which component ensures transactions are properly executed, prevents conflicts
between concurrent transactions, and restores the database to a consistent state in
the event of a transaction or system failure?
A. Load Manager
B. Warehouse Manager
C. Storage Manager
D. Transaction Manager
Answer: D
Rationale: The Transaction Manager ensures transactions are properly executed,
prevents conflicts between concurrent transactions, and restores the database to a
consistent state in the event of failure. It is a key component of ACID compliance.
Question 10
What is documented in the data model but not tracked with data in the database,
representing logical rules and constraints that govern the data but aren't explicitly
stored as data themselves?
A. Tangible Entity
B. Primary Key
C. Intangible Entity
D. Physical Attribute
Answer: C
Rationale: An Intangible Entity is documented in the data model but not tracked
with data in the database. These represent logical rules and constraints that govern
the data but aren't explicitly stored as data themselves.
Question 11
What ensures data is consistent with structural and business rules in a database
system?
A. Laws
B. Functions
C. Definitions
D. Rules
Answer: D
pg. 4
