1 | Page
D426 WGU EXAM 2025 UPDATED ACTUAL
EXAM WITH CORRECT SOLUTIONS.
Software that helps business users interact with database
systems. - correct answer- Database Application
Responsible for securing the database system against
unauthorized users. A database administrator enforces
procedures for user access and database system availability. -
correct answer- Database Administrator
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. - correct
answer- Authorization
Database systems ensure data is consistent with structural and
business rules. - correct answer- Rules
Interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Performs query optimization to ensure the most efficient
,2 | Page
instructions are executed on the data. - correct answer- Query
Processor
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. - correct answer-
Storage Manager
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. -
correct answer- Transaction Manager
Data about the database, such as column names and the
number of rows in each table. - correct answer- Metadata
Stores data in tables, columns, and rows, similar to a
spreadsheet. - correct answer- Relational Database
All _________ ________ systems support the SQL query
language. - correct answer- Relational Database
, 3 | Page
Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records. - correct answer-
Relational Database
The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data. - correct answer-
MongoDB (NoSQL)
INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table. - correct answer- SQL
Statements
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. - correct answer- CREATE TABLE
(Statement)
INT stores integer values.
D426 WGU EXAM 2025 UPDATED ACTUAL
EXAM WITH CORRECT SOLUTIONS.
Software that helps business users interact with database
systems. - correct answer- Database Application
Responsible for securing the database system against
unauthorized users. A database administrator enforces
procedures for user access and database system availability. -
correct answer- Database Administrator
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. - correct
answer- Authorization
Database systems ensure data is consistent with structural and
business rules. - correct answer- Rules
Interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Performs query optimization to ensure the most efficient
,2 | Page
instructions are executed on the data. - correct answer- Query
Processor
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. - correct answer-
Storage Manager
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. -
correct answer- Transaction Manager
Data about the database, such as column names and the
number of rows in each table. - correct answer- Metadata
Stores data in tables, columns, and rows, similar to a
spreadsheet. - correct answer- Relational Database
All _________ ________ systems support the SQL query
language. - correct answer- Relational Database
, 3 | Page
Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records. - correct answer-
Relational Database
The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data. - correct answer-
MongoDB (NoSQL)
INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table. - correct answer- SQL
Statements
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. - correct answer- CREATE TABLE
(Statement)
INT stores integer values.
