WGU D426 Data Management exam with
complete solutions 2024/2025
Authorization
Which requirement within large, complex databases ensures users have limited
access to the database?
Conceptual design
Which design type specifi es database requirements without regard to a specifi c
database system?
They are logical constraints that ensure the data is valid.
What characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect
Which event will result in an error code and error description when using MySQL
Server?
INT
Which data type should be used to store whole integer values, such as age?
MySQL Command-Line Client
Which text-based interface is included in the MySQL Server Download?
MySQL
Which database system includes the World database during its installation?
Structured Query Language
What is the standardized language of relational database systems?
Data Control Language (DCL)
Which SQL sublanguage is used to manage database access?
Data Transaction Language (DTL)
Which SQL sublanguage is used to roll back database changes?
hh:mm:ss
Which format is used by the TIME data type in MySQL?
OR
Which MySQL operator is the last in the order of operator precedence?
, <=
Which operator is used to compare columns from the left and right tables in
MySQL?
CROSS
Which type of join combines two tables without comparing columns?
Equijoin
Which type of join compares columns using only the = operator?
EQUIJOIN
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
In a nested query, the outer query is evaluated first.
What is another name for a subquery?
IN
Which operator is used to compare against a list of values when determining a
match in a WHERE clause?
%
Which wildcard character is used to represent zero or more characters when
searching for a specified pattern using a LIKE operator?
MIN
Which function is considered an aggregating function in SQL?
GROUP BY
Which clause or function is used with aggregate functions to produce summary
rows?
Inner Join
Which type of join returns only the matching values when selecting rows from
two or more tables?
Inner Join
Which join type selects only matching left and right table rows?
Materialized View
Which phrase refers to the view in which data is persisted and is automatically
changed as the underlying data is changed?
UPDATE Employee SET Salary = 50000 WHERE ID = 1;
Which SQL command uses the correct syntax to update the salary of an
employee in the Employee table?
Metadata
What describes elements such as column name and data type?
Tuple
Which term identifies an ordered collection of elements enclosed in parenthesis
in a tablespace?
complete solutions 2024/2025
Authorization
Which requirement within large, complex databases ensures users have limited
access to the database?
Conceptual design
Which design type specifi es database requirements without regard to a specifi c
database system?
They are logical constraints that ensure the data is valid.
What characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect
Which event will result in an error code and error description when using MySQL
Server?
INT
Which data type should be used to store whole integer values, such as age?
MySQL Command-Line Client
Which text-based interface is included in the MySQL Server Download?
MySQL
Which database system includes the World database during its installation?
Structured Query Language
What is the standardized language of relational database systems?
Data Control Language (DCL)
Which SQL sublanguage is used to manage database access?
Data Transaction Language (DTL)
Which SQL sublanguage is used to roll back database changes?
hh:mm:ss
Which format is used by the TIME data type in MySQL?
OR
Which MySQL operator is the last in the order of operator precedence?
, <=
Which operator is used to compare columns from the left and right tables in
MySQL?
CROSS
Which type of join combines two tables without comparing columns?
Equijoin
Which type of join compares columns using only the = operator?
EQUIJOIN
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
In a nested query, the outer query is evaluated first.
What is another name for a subquery?
IN
Which operator is used to compare against a list of values when determining a
match in a WHERE clause?
%
Which wildcard character is used to represent zero or more characters when
searching for a specified pattern using a LIKE operator?
MIN
Which function is considered an aggregating function in SQL?
GROUP BY
Which clause or function is used with aggregate functions to produce summary
rows?
Inner Join
Which type of join returns only the matching values when selecting rows from
two or more tables?
Inner Join
Which join type selects only matching left and right table rows?
Materialized View
Which phrase refers to the view in which data is persisted and is automatically
changed as the underlying data is changed?
UPDATE Employee SET Salary = 50000 WHERE ID = 1;
Which SQL command uses the correct syntax to update the salary of an
employee in the Employee table?
Metadata
What describes elements such as column name and data type?
Tuple
Which term identifies an ordered collection of elements enclosed in parenthesis
in a tablespace?
