5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
Database Concepts Exam Prep, WGU - D426:
Objective Assessment, WGU D426 V2\COMPLETE
QUESTIONS AND ANSWERS \VERIFIED
ANSWERS
Phase that adds indexes and Physical design
specifies how tables are
organized on storage
media, affecting query
processing speed but not
query results.
Principle that physical Data independence
design changes do not
affect query results.
Application Programming API
Interface used to simplify the
use of SQL with a general-
purpose language.
Text interface included in MySQL Command-Line Client
the MySQL Server
download, providing error
codes and descriptions for
SQL statements.
Ordered collection of Tuple
elements enclosed in
parentheses.
Organizes data in tables, Data structure
with tables having columns
and rows.
Based on business policy Business rules
and specific to a particular
1/76
,5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
database.
Explicit values like strings, Literals
numerics, or binaries.
Words with special meanings Keywords
in SQL like SELECT, FROM,
WHERE.
Objects from the database Identifiers
like tables, columns, etc.
Statements intended for Comments
humans and ignored by
the database when parsing
an SQL statement.
SQL language divided into SQL sublanguages
five sublanguages: DDL,
DQL, DML, DCL, DTL.
Single column value in a row Cell
of a table.
Data type for whole Integer
numbers without a decimal
point
Data type with a storage TINYINT
size of 1 byte, representing
a small range of signed and
unsigned integers
2/76
,5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
Data type with a storage SMALLINT
size of 2 bytes,
representing a larger range
of signed and unsigned
integers
Data type with a storage MEDIUMINT
size of 3 bytes,
representing a medium
range of signed and
unsigned integers
Data type with a storage INTEGER or INT
size of 4 bytes, representing
a large range of signed and
unsigned integers
Data type with a storage BIGINT
size of 8 bytes,
representing a very large
range of signed and
unsigned integers
Operators (+, -, *, /, %, ^) Arithmetic Operators
used for basic arithmetic
operations in SQL
Operators (=, !=, <, <=, >) Comparison Operators
used to compare values in SQL
Modifies existing rows in a UPDATE statement
table using the SET clause
and an optional WHERE
clause
Deletes existing rows in a DELETE statement
table using the FROM
keyword and an optional
WHERE clause
Deletes all rows from a TRUNCATE statement
table, similar to DELETE but
with minor differences
3/76
, 5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
Column(s) used to identify Primary keys
a row uniquely in a table
Numeric columns that Auto-increment columns
automatically increment
their value when a new row
is inserted
Constraint that ensures FOREIGN KEY constraint
the values in a column
match values in a
primary key column in
another table
Actions (RESTRICT, SET NULL, Referential integrity actions
SET
DEFAULT, CASCADE) taken
when referential integrity
is violated
Operator used to determine BETWEEN operator
if a value falls within a
specified range
Operator used in WHERE LIKE operator
clauses to match patterns
in text values
Clause used to sort selected ORDER BY clause
rows in SQL
Functions (COUNT, MIN, Aggregate functions
MAX, SUM, AVG)
that summarize data from
multiple rows
Clause used with GROUP BY HAVING clause
to filter grouped results in
SQL
Combines data from two Join
tables based on a related
column between them
Joins that compare columns Equijoins
of two tables using the =
operator
4/76
Database Concepts Exam Prep, WGU - D426:
Objective Assessment, WGU D426 V2\COMPLETE
QUESTIONS AND ANSWERS \VERIFIED
ANSWERS
Phase that adds indexes and Physical design
specifies how tables are
organized on storage
media, affecting query
processing speed but not
query results.
Principle that physical Data independence
design changes do not
affect query results.
Application Programming API
Interface used to simplify the
use of SQL with a general-
purpose language.
Text interface included in MySQL Command-Line Client
the MySQL Server
download, providing error
codes and descriptions for
SQL statements.
Ordered collection of Tuple
elements enclosed in
parentheses.
Organizes data in tables, Data structure
with tables having columns
and rows.
Based on business policy Business rules
and specific to a particular
1/76
,5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
database.
Explicit values like strings, Literals
numerics, or binaries.
Words with special meanings Keywords
in SQL like SELECT, FROM,
WHERE.
Objects from the database Identifiers
like tables, columns, etc.
Statements intended for Comments
humans and ignored by
the database when parsing
an SQL statement.
SQL language divided into SQL sublanguages
five sublanguages: DDL,
DQL, DML, DCL, DTL.
Single column value in a row Cell
of a table.
Data type for whole Integer
numbers without a decimal
point
Data type with a storage TINYINT
size of 1 byte, representing
a small range of signed and
unsigned integers
2/76
,5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
Data type with a storage SMALLINT
size of 2 bytes,
representing a larger range
of signed and unsigned
integers
Data type with a storage MEDIUMINT
size of 3 bytes,
representing a medium
range of signed and
unsigned integers
Data type with a storage INTEGER or INT
size of 4 bytes, representing
a large range of signed and
unsigned integers
Data type with a storage BIGINT
size of 8 bytes,
representing a very large
range of signed and
unsigned integers
Operators (+, -, *, /, %, ^) Arithmetic Operators
used for basic arithmetic
operations in SQL
Operators (=, !=, <, <=, >) Comparison Operators
used to compare values in SQL
Modifies existing rows in a UPDATE statement
table using the SET clause
and an optional WHERE
clause
Deletes existing rows in a DELETE statement
table using the FROM
keyword and an optional
WHERE clause
Deletes all rows from a TRUNCATE statement
table, similar to DELETE but
with minor differences
3/76
, 5/29/25, 9:41 PM Database Concepts Exam Prep, WGU - D426: Objective Assessment, WGU D426 V2
Column(s) used to identify Primary keys
a row uniquely in a table
Numeric columns that Auto-increment columns
automatically increment
their value when a new row
is inserted
Constraint that ensures FOREIGN KEY constraint
the values in a column
match values in a
primary key column in
another table
Actions (RESTRICT, SET NULL, Referential integrity actions
SET
DEFAULT, CASCADE) taken
when referential integrity
is violated
Operator used to determine BETWEEN operator
if a value falls within a
specified range
Operator used in WHERE LIKE operator
clauses to match patterns
in text values
Clause used to sort selected ORDER BY clause
rows in SQL
Functions (COUNT, MIN, Aggregate functions
MAX, SUM, AVG)
that summarize data from
multiple rows
Clause used with GROUP BY HAVING clause
to filter grouped results in
SQL
Combines data from two Join
tables based on a related
column between them
Joins that compare columns Equijoins
of two tables using the =
operator
4/76
