WGU D426 Data Management – Foundations OA
Exam 2026/2027 – Questions, Answers &
Rationales
Table of Contents
1. Database Fundamentals
2. Relational Database Concepts
3. Entity-Relationship Modeling
4. Relational Algebra & SQL Foundations
5. SQL Queries & Data Manipulation
6. Database Design & Normalization
7. Keys, Constraints & Integrity
8. Transactions, Security & Data Management
9. Comprehensive D426 Review
SECTION 1 — DATABASE FUNDAMENTALS
Question 1
What is the primary purpose of a database?
A. To replace an operating system
B. To store, organize, and manage data efficiently
C. To increase processor speed
D. To create network connections
Answer: B
Rationale: A database is designed to store, organize, retrieve, and manage
data efficiently. Database management systems also provide mechanisms for
security, integrity, concurrency, and controlled access.
,Question 2
What does DBMS stand for?
A. Data Backup Management Service
B. Database Management System
C. Database Memory Storage
D. Digital Business Management System
Answer: B
Rationale: A Database Management System (DBMS) is software used to
create, maintain, access, and manage databases.
Question 3
Which is an example of a relational DBMS?
A. PostgreSQL
B. JPEG
C. HTML
D. Ethernet
Answer: A
Rationale: PostgreSQL is a relational database management system. Other
examples include MySQL, Oracle Database, Microsoft SQL Server, and SQLite.
Question 4
What is data?
A. Only numerical information
B. Raw facts that can be processed into meaningful information
C. Only information stored on paper
D. A computer program
Answer: B
,Rationale: Data consists of raw facts or observations. When processed and
interpreted, data can become useful information.
Question 5
Which statement best describes information?
A. Completely unprocessed facts
B. Data that has been processed and given meaning
C. Only database commands
D. Computer hardware
Answer: B
Rationale: Information is data that has been organized or processed so that it
becomes meaningful and useful.
Question 6
What is a table in a relational database?
A. A collection of related rows and columns
B. A programming language
C. A network protocol
D. A backup device
Answer: A
Rationale: Relational databases organize data into tables consisting of rows
and columns.
Question 7
In a relational table, a row is commonly called a:
A. Attribute
B. Record or tuple
C. Domain
D. Schema
, Answer: B
Rationale: A row represents one record or tuple. For example, one row in a
STUDENT table could represent one student.
Question 8
In a relational database, a column is commonly called a:
A. Tuple
B. Record
C. Attribute
D. Relationship
Answer: C
Rationale: Columns represent attributes or characteristics of the entities
represented by the table.
Question 9
Which component defines the structure of a database?
A. Schema
B. Monitor
C. Keyboard
D. Router
Answer: A
Rationale: A database schema describes the structure of database objects
such as tables, columns, relationships, constraints, and data types.
Question 10
What is metadata?
A. Data about data
B. Deleted data
Exam 2026/2027 – Questions, Answers &
Rationales
Table of Contents
1. Database Fundamentals
2. Relational Database Concepts
3. Entity-Relationship Modeling
4. Relational Algebra & SQL Foundations
5. SQL Queries & Data Manipulation
6. Database Design & Normalization
7. Keys, Constraints & Integrity
8. Transactions, Security & Data Management
9. Comprehensive D426 Review
SECTION 1 — DATABASE FUNDAMENTALS
Question 1
What is the primary purpose of a database?
A. To replace an operating system
B. To store, organize, and manage data efficiently
C. To increase processor speed
D. To create network connections
Answer: B
Rationale: A database is designed to store, organize, retrieve, and manage
data efficiently. Database management systems also provide mechanisms for
security, integrity, concurrency, and controlled access.
,Question 2
What does DBMS stand for?
A. Data Backup Management Service
B. Database Management System
C. Database Memory Storage
D. Digital Business Management System
Answer: B
Rationale: A Database Management System (DBMS) is software used to
create, maintain, access, and manage databases.
Question 3
Which is an example of a relational DBMS?
A. PostgreSQL
B. JPEG
C. HTML
D. Ethernet
Answer: A
Rationale: PostgreSQL is a relational database management system. Other
examples include MySQL, Oracle Database, Microsoft SQL Server, and SQLite.
Question 4
What is data?
A. Only numerical information
B. Raw facts that can be processed into meaningful information
C. Only information stored on paper
D. A computer program
Answer: B
,Rationale: Data consists of raw facts or observations. When processed and
interpreted, data can become useful information.
Question 5
Which statement best describes information?
A. Completely unprocessed facts
B. Data that has been processed and given meaning
C. Only database commands
D. Computer hardware
Answer: B
Rationale: Information is data that has been organized or processed so that it
becomes meaningful and useful.
Question 6
What is a table in a relational database?
A. A collection of related rows and columns
B. A programming language
C. A network protocol
D. A backup device
Answer: A
Rationale: Relational databases organize data into tables consisting of rows
and columns.
Question 7
In a relational table, a row is commonly called a:
A. Attribute
B. Record or tuple
C. Domain
D. Schema
, Answer: B
Rationale: A row represents one record or tuple. For example, one row in a
STUDENT table could represent one student.
Question 8
In a relational database, a column is commonly called a:
A. Tuple
B. Record
C. Attribute
D. Relationship
Answer: C
Rationale: Columns represent attributes or characteristics of the entities
represented by the table.
Question 9
Which component defines the structure of a database?
A. Schema
B. Monitor
C. Keyboard
D. Router
Answer: A
Rationale: A database schema describes the structure of database objects
such as tables, columns, relationships, constraints, and data types.
Question 10
What is metadata?
A. Data about data
B. Deleted data
