WGU D426 Data Management – Foundations Objective
Assessment (OA) Exam Test Bank | Comprehensive Practice
Exam with Actual Exam Questions, Verified Correct Answers
and Detailed Rationales | Update 2026/2027 –Graded A+
Question 1. What is the primary purpose of a database?
A. To replace an operating system
B. To organize, store, and manage data efficiently
C. To increase internet bandwidth
D. To design computer hardware
Correct Answer: B. To organize, store, and manage data efficiently
Rationale: A database is designed to store and organize related data so that it
can be accessed, updated, retrieved, and managed efficiently. Database
systems also provide mechanisms for security, integrity, concurrency, and
recovery.
Question 2. Which component of a relational database stores data about a
particular subject?
A. Table
B. Query
C. Form
D. Report
Correct Answer: A. Table
Rationale: A table stores data about a specific subject or entity. For example,
a STUDENT table might contain student identification numbers, names, and
contact information. Rows represent individual records, while columns
represent attributes.
Question 3. In a relational database, what does a row typically represent?
,A. An attribute
B. A field definition
C. A record
D. A relationship type
Correct Answer: C. A record
Rationale: Each row in a relational table represents one record or instance of
an entity. For example, one row in a CUSTOMER table could represent one
customer.
Question 4. What does a column in a relational table represent?
A. A record
B. An attribute
C. A database
D. A relationship
Correct Answer: B. An attribute
Rationale: A column represents an attribute or characteristic of the entity
represented by the table. For example, CustomerID, FirstName, and Email
could be attributes of a CUSTOMER entity.
Question 5. Which key uniquely identifies each row in a relational table?
A. Foreign key
B. Candidate key
C. Primary key
D. Alternate key
Correct Answer: C. Primary key
Rationale: A primary key uniquely identifies every record in a table. A
primary key cannot contain duplicate values, and under standard relational
design it should not contain NULL values.
,Question 6. Which statement about a primary key is correct?
A. It must contain duplicate values
B. It can normally contain NULL values
C. It uniquely identifies each row
D. It must always be a text field
Correct Answer: C. It uniquely identifies each row
Rationale: The defining purpose of a primary key is to provide a unique
identifier for each row. The key can be composed of one column or multiple
columns.
Question 7. What is a foreign key used primarily to accomplish?
A. Encrypt data
B. Establish a relationship between tables
C. Sort records alphabetically
D. Remove duplicate columns automatically
Correct Answer: B. Establish a relationship between tables
Rationale: A foreign key is a column or group of columns in one table that
references a candidate or primary key in another table. It allows related
records to be connected and supports referential integrity.
Question 8. A CUSTOMER table has CustomerID as its primary key. An ORDER
table contains CustomerID as a foreign key. What relationship does this most
commonly represent?
A. One customer can have many orders
B. One customer can have only one order
C. One order must belong to many customers
D. Customers and orders cannot be related
, Correct Answer: A. One customer can have many orders
Rationale: A customer's primary key can appear multiple times as a foreign
key in the ORDER table. This represents a one-to-many relationship: one
customer may place many orders, while each order belongs to one customer.
Question 9. What is a DBMS?
A. Data Backup Management Standard
B. Database Management System
C. Database Memory Structure
D. Digital Business Management Service
Correct Answer: B. Database Management System
Rationale: A Database Management System is software used to create, store,
retrieve, update, secure, and administer databases. Examples include MySQL,
PostgreSQL, Oracle Database, Microsoft SQL Server, and Microsoft Access.
Question 10. Which language is primarily used to interact with relational
databases?
A. HTML
B. SQL
C. CSS
D. XML
Correct Answer: B. SQL
Rationale: Structured Query Language, or SQL, is the standard language used
to define, manipulate, query, and control data in relational database systems.
Question 11. Which SQL statement is used to retrieve data?
A. SELECT
B. INSERT
Assessment (OA) Exam Test Bank | Comprehensive Practice
Exam with Actual Exam Questions, Verified Correct Answers
and Detailed Rationales | Update 2026/2027 –Graded A+
Question 1. What is the primary purpose of a database?
A. To replace an operating system
B. To organize, store, and manage data efficiently
C. To increase internet bandwidth
D. To design computer hardware
Correct Answer: B. To organize, store, and manage data efficiently
Rationale: A database is designed to store and organize related data so that it
can be accessed, updated, retrieved, and managed efficiently. Database
systems also provide mechanisms for security, integrity, concurrency, and
recovery.
Question 2. Which component of a relational database stores data about a
particular subject?
A. Table
B. Query
C. Form
D. Report
Correct Answer: A. Table
Rationale: A table stores data about a specific subject or entity. For example,
a STUDENT table might contain student identification numbers, names, and
contact information. Rows represent individual records, while columns
represent attributes.
Question 3. In a relational database, what does a row typically represent?
,A. An attribute
B. A field definition
C. A record
D. A relationship type
Correct Answer: C. A record
Rationale: Each row in a relational table represents one record or instance of
an entity. For example, one row in a CUSTOMER table could represent one
customer.
Question 4. What does a column in a relational table represent?
A. A record
B. An attribute
C. A database
D. A relationship
Correct Answer: B. An attribute
Rationale: A column represents an attribute or characteristic of the entity
represented by the table. For example, CustomerID, FirstName, and Email
could be attributes of a CUSTOMER entity.
Question 5. Which key uniquely identifies each row in a relational table?
A. Foreign key
B. Candidate key
C. Primary key
D. Alternate key
Correct Answer: C. Primary key
Rationale: A primary key uniquely identifies every record in a table. A
primary key cannot contain duplicate values, and under standard relational
design it should not contain NULL values.
,Question 6. Which statement about a primary key is correct?
A. It must contain duplicate values
B. It can normally contain NULL values
C. It uniquely identifies each row
D. It must always be a text field
Correct Answer: C. It uniquely identifies each row
Rationale: The defining purpose of a primary key is to provide a unique
identifier for each row. The key can be composed of one column or multiple
columns.
Question 7. What is a foreign key used primarily to accomplish?
A. Encrypt data
B. Establish a relationship between tables
C. Sort records alphabetically
D. Remove duplicate columns automatically
Correct Answer: B. Establish a relationship between tables
Rationale: A foreign key is a column or group of columns in one table that
references a candidate or primary key in another table. It allows related
records to be connected and supports referential integrity.
Question 8. A CUSTOMER table has CustomerID as its primary key. An ORDER
table contains CustomerID as a foreign key. What relationship does this most
commonly represent?
A. One customer can have many orders
B. One customer can have only one order
C. One order must belong to many customers
D. Customers and orders cannot be related
, Correct Answer: A. One customer can have many orders
Rationale: A customer's primary key can appear multiple times as a foreign
key in the ORDER table. This represents a one-to-many relationship: one
customer may place many orders, while each order belongs to one customer.
Question 9. What is a DBMS?
A. Data Backup Management Standard
B. Database Management System
C. Database Memory Structure
D. Digital Business Management Service
Correct Answer: B. Database Management System
Rationale: A Database Management System is software used to create, store,
retrieve, update, secure, and administer databases. Examples include MySQL,
PostgreSQL, Oracle Database, Microsoft SQL Server, and Microsoft Access.
Question 10. Which language is primarily used to interact with relational
databases?
A. HTML
B. SQL
C. CSS
D. XML
Correct Answer: B. SQL
Rationale: Structured Query Language, or SQL, is the standard language used
to define, manipulate, query, and control data in relational database systems.
Question 11. Which SQL statement is used to retrieve data?
A. SELECT
B. INSERT
