WGU - D426: Objective Assessment
2025/2026 Exam Questions and Answers
| A+ Score Assured
Database Application - 🧠 ANSWER ✔✔Software that helps business users
interact with database systems.
Database Administrator - 🧠 ANSWER ✔✔Responsible for securing the
database system against unauthorized users. A database administrator
enforces procedures for user access and database system availability.
Authorization - 🧠 ANSWER ✔✔Many database users should have limited
access to specific tables, columns, or rows of a database. Database
systems authorize individual users to access specific data.
Rules - 🧠 ANSWER ✔✔Database systems ensure data is consistent with
structural and business rules.
Query Processor - 🧠 ANSWER ✔✔Interprets queries, creates a plan to
modify the database or retrieve data, and returns query results to the
1
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,application. Performs query optimization to ensure the most efficient
instructions are executed on the data.
Storage Manager - 🧠 ANSWER ✔✔Translates the query processor
instructions into low-level file-system commands that modify or retrieve
data. Database sizes range from megabytes to many terabytes, so the
storage manager uses indexes to quickly locate data.
Transaction Manager - 🧠 ANSWER ✔✔Ensures transactions are properly
executed. The transaction manager prevents conflicts between concurrent
transactions. The transaction manager also restores the database to a
consistent state in the event of a transaction or system failure.
Metadata - 🧠 ANSWER ✔✔Data about the database, such as column
names and the number of rows in each table.
Relational Database - 🧠 ANSWER ✔✔Stores data in tables, columns, and
rows, similar to a spreadsheet.
Relational Database - 🧠 ANSWER ✔✔All _________ ________ systems
support the SQL query language.
2
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, Relational Database - 🧠 ANSWER ✔✔Relational systems are ideal for
databases that require an accurate record of every transaction, such as
banking, airline reservation systems, and student records.
MongoDB (NoSQL) - 🧠 ANSWER ✔✔The newer non-relational systems are
called NoSQL, for 'not only SQL', and are optimized for big data.
SQL Statements - 🧠 ANSWER ✔✔INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
CREATE TABLE (Statement) - 🧠 ANSWER ✔✔A statement that creates a
new table by specifying the table and column names. Each column is
assigned a data type that indicates the format of column values. Data types
can be numeric, textual, or complex.
Data Type - 🧠 ANSWER ✔✔INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
3
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
2025/2026 Exam Questions and Answers
| A+ Score Assured
Database Application - 🧠 ANSWER ✔✔Software that helps business users
interact with database systems.
Database Administrator - 🧠 ANSWER ✔✔Responsible for securing the
database system against unauthorized users. A database administrator
enforces procedures for user access and database system availability.
Authorization - 🧠 ANSWER ✔✔Many database users should have limited
access to specific tables, columns, or rows of a database. Database
systems authorize individual users to access specific data.
Rules - 🧠 ANSWER ✔✔Database systems ensure data is consistent with
structural and business rules.
Query Processor - 🧠 ANSWER ✔✔Interprets queries, creates a plan to
modify the database or retrieve data, and returns query results to the
1
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,application. Performs query optimization to ensure the most efficient
instructions are executed on the data.
Storage Manager - 🧠 ANSWER ✔✔Translates the query processor
instructions into low-level file-system commands that modify or retrieve
data. Database sizes range from megabytes to many terabytes, so the
storage manager uses indexes to quickly locate data.
Transaction Manager - 🧠 ANSWER ✔✔Ensures transactions are properly
executed. The transaction manager prevents conflicts between concurrent
transactions. The transaction manager also restores the database to a
consistent state in the event of a transaction or system failure.
Metadata - 🧠 ANSWER ✔✔Data about the database, such as column
names and the number of rows in each table.
Relational Database - 🧠 ANSWER ✔✔Stores data in tables, columns, and
rows, similar to a spreadsheet.
Relational Database - 🧠 ANSWER ✔✔All _________ ________ systems
support the SQL query language.
2
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, Relational Database - 🧠 ANSWER ✔✔Relational systems are ideal for
databases that require an accurate record of every transaction, such as
banking, airline reservation systems, and student records.
MongoDB (NoSQL) - 🧠 ANSWER ✔✔The newer non-relational systems are
called NoSQL, for 'not only SQL', and are optimized for big data.
SQL Statements - 🧠 ANSWER ✔✔INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
CREATE TABLE (Statement) - 🧠 ANSWER ✔✔A statement that creates a
new table by specifying the table and column names. Each column is
assigned a data type that indicates the format of column values. Data types
can be numeric, textual, or complex.
Data Type - 🧠 ANSWER ✔✔INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
3
COPYRIGHT@SARAHROSAPERAL 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
