WGU - D426: Objective
Assessment Test Questions
And Answers 2025
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 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.
Assessment Test Questions
And Answers 2025
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 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.
