1
WGU - D426: Objective Assessment Questions with
Answers (100% Correct Answers
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.
© 2025 All rights reserved
,2
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.
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.
© 2025 All rights reserved
, 3
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.
Database Design Answer: Analysis
Logical design
© 2025 All rights reserved
WGU - D426: Objective Assessment Questions with
Answers (100% Correct Answers
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.
© 2025 All rights reserved
,2
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.
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.
© 2025 All rights reserved
, 3
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.
Database Design Answer: Analysis
Logical design
© 2025 All rights reserved
