WGU D426 Exam Questions with Correct Answers Latest Update 2025-2026
Database Application - Answers Software for user interaction with databases.
Database Administrator - Answers Secures database against unauthorized access.
Authorization - Answers Limits user access to specific database data.
Rules - Answers Ensure data consistency with business requirements.
Query Processor - Answers Interprets queries and optimizes database instructions.
Storage Manager - Answers Translates instructions into file-system commands.
Transaction Manager - Answers Ensures proper execution of database transactions.
MongoDB - Answers Open-source NoSQL database for unstructured data.
INSERT - Answers SQL command to add rows to a table.
SELECT - Answers SQL command to retrieve data from a table.
UPDATE - Answers SQL command to modify existing table data.
DELETE - Answers SQL command to remove rows from a table.
CREATE TABLE - Answers SQL statement to define a new table.
Data Type - Answers Specifies format of column values in a table.
INT - Answers Data type for storing integer values.
DECIMAL - Answers Data type for fractional numeric values.
VARCHAR - Answers Data type for variable-length textual values.
DATE - Answers Data type for storing date values.
Analysis Phase - Answers Specifies database requirements without system specifics.
Logical Design - Answers Implements requirements in a specific database system.
Physical Design - Answers Organizes tables on storage media for efficiency.
Data Independence - Answers Physical design changes do not affect query results.
API - Answers Interface for database programs with programming languages.
, Tuple - Answers Ordered collection of elements, e.g., (a, b, c).
Row - Answers Unnamed tuple of values in a table.
Column - Answers Named set of values with a specific data type.
Cell - Answers Single value at the intersection of a row and column.
DROP TABLE - Answers SQL statement to delete a table and its data.
ALTER TABLE - Answers SQL statement to modify existing table structure.
Literals - Answers Explicit values in string, numeric, or binary format.
Keywords - Answers Special words with specific meanings in SQL.
Identifiers - Answers Names of database objects like tables and columns.
Comments - Answers Annotations in SQL ignored by the database.
SQL Sublanguages - Answers Categories of SQL for different database operations.
TINYINT - Answers 1 byte. Signed range: -128 to 127. Unsigned range: 0 to 255.
SMALLINT - Answers 2 bytes. Signed range: -32,768 to 32,767. Unsigned range: 0 to 65,535.
MEDIUMINT - Answers 3 bytes. Signed range: -8,388,608 to 8,388,607. Unsigned range: 0 to
16,777,215.
INTEGER or INT - Answers 4 bytes. Signed range: -2,147,483,648 to 2,147,483,647. Unsigned
range: 0 to 4,294,967,295.
BIGINT - Answers 8 bytes. Signed range: -263 to 263 -1. Unsigned range: 0 to 264 -1.
Arithmetic Operator + - Answers Adds two numeric values. Example: 4 + 37.
Arithmetic Operator - (unary) - Answers Reverses the sign of one numeric value. Example: -(-2) =
2.
Arithmetic Operator - (binary) - Answers Subtracts one numeric value from another. Example: 11
- 56.
Arithmetic Operator * - Answers Multiplies two numeric values. Example: 3 * 5 = 15.
Arithmetic Operator / - Answers Divides one numeric value by another. Example: .
Arithmetic Operator % (modulo) - Answers Divides one numeric value by another and returns the
integer remainder. Example: 5 % 21.
Database Application - Answers Software for user interaction with databases.
Database Administrator - Answers Secures database against unauthorized access.
Authorization - Answers Limits user access to specific database data.
Rules - Answers Ensure data consistency with business requirements.
Query Processor - Answers Interprets queries and optimizes database instructions.
Storage Manager - Answers Translates instructions into file-system commands.
Transaction Manager - Answers Ensures proper execution of database transactions.
MongoDB - Answers Open-source NoSQL database for unstructured data.
INSERT - Answers SQL command to add rows to a table.
SELECT - Answers SQL command to retrieve data from a table.
UPDATE - Answers SQL command to modify existing table data.
DELETE - Answers SQL command to remove rows from a table.
CREATE TABLE - Answers SQL statement to define a new table.
Data Type - Answers Specifies format of column values in a table.
INT - Answers Data type for storing integer values.
DECIMAL - Answers Data type for fractional numeric values.
VARCHAR - Answers Data type for variable-length textual values.
DATE - Answers Data type for storing date values.
Analysis Phase - Answers Specifies database requirements without system specifics.
Logical Design - Answers Implements requirements in a specific database system.
Physical Design - Answers Organizes tables on storage media for efficiency.
Data Independence - Answers Physical design changes do not affect query results.
API - Answers Interface for database programs with programming languages.
, Tuple - Answers Ordered collection of elements, e.g., (a, b, c).
Row - Answers Unnamed tuple of values in a table.
Column - Answers Named set of values with a specific data type.
Cell - Answers Single value at the intersection of a row and column.
DROP TABLE - Answers SQL statement to delete a table and its data.
ALTER TABLE - Answers SQL statement to modify existing table structure.
Literals - Answers Explicit values in string, numeric, or binary format.
Keywords - Answers Special words with specific meanings in SQL.
Identifiers - Answers Names of database objects like tables and columns.
Comments - Answers Annotations in SQL ignored by the database.
SQL Sublanguages - Answers Categories of SQL for different database operations.
TINYINT - Answers 1 byte. Signed range: -128 to 127. Unsigned range: 0 to 255.
SMALLINT - Answers 2 bytes. Signed range: -32,768 to 32,767. Unsigned range: 0 to 65,535.
MEDIUMINT - Answers 3 bytes. Signed range: -8,388,608 to 8,388,607. Unsigned range: 0 to
16,777,215.
INTEGER or INT - Answers 4 bytes. Signed range: -2,147,483,648 to 2,147,483,647. Unsigned
range: 0 to 4,294,967,295.
BIGINT - Answers 8 bytes. Signed range: -263 to 263 -1. Unsigned range: 0 to 264 -1.
Arithmetic Operator + - Answers Adds two numeric values. Example: 4 + 37.
Arithmetic Operator - (unary) - Answers Reverses the sign of one numeric value. Example: -(-2) =
2.
Arithmetic Operator - (binary) - Answers Subtracts one numeric value from another. Example: 11
- 56.
Arithmetic Operator * - Answers Multiplies two numeric values. Example: 3 * 5 = 15.
Arithmetic Operator / - Answers Divides one numeric value by another. Example: .
Arithmetic Operator % (modulo) - Answers Divides one numeric value by another and returns the
integer remainder. Example: 5 % 21.
