WGU Data Management - Foundations - D426
10. Which SQL sublanguage is used to roll back database changes?
Data Transaction Language (DTL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL) - ANSWER-Data Transaction Language (DTL)
11. Which format is used by the TIME data type in MySQL?
YYYY-MM-DD
YYYY-MM-DD hh:mm:ss
hh:mm:ss
hh:mm:ss YYYY-MM-DD - ANSWER-hh:mm:ss
12. Which MySQL operator is the last in the order of operator precedence?
-
OR
NOT
= - ANSWER-OR
13. Which operator is used to compare columns from the left and right tables in
MySQL?
<=
+
=
* - ANSWER-=
14. Which type of join combines two tables without comparing columns?
SELF
EQUIJOIN
OUTER
CROSS - ANSWER-CROSS
15. Which type of join compares columns using only the = operator?
Equijoin
Non-equijoin
Outer join
Inner join - ANSWER-Equijoin
16. Which type of join is demonstrated by the following query?
, SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
NON-EQUIJOIN
SELF JOIN
CROSS JOIN
EQUIJOIN - ANSWER-EQUIJOIN
17. What is another name for a subquery?
Outer query
Nested query
Correlated query
Search query - ANSWER-Nested query
18. Which operator is used to compare against a list of values when determining a
match in a WHERE clause?
IN
BETWEEN
LIKE
OR - ANSWER-IN
19. Which wildcard character is used to represent zero or more characters when
searching for a specified pattern using a LIKE operator?
%
_
<
> - ANSWER-%
20. Which function is considered an aggregating function in SQL?
TRIM
REPLACE
MIN
SUBSTRING - ANSWER-MIN
21. Which clause or function is used with aggregate functions to produce summary
rows?
TRIM
REPLACE
ORDER BY
GROUP BY - ANSWER-GROUP BY
10. Which SQL sublanguage is used to roll back database changes?
Data Transaction Language (DTL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL) - ANSWER-Data Transaction Language (DTL)
11. Which format is used by the TIME data type in MySQL?
YYYY-MM-DD
YYYY-MM-DD hh:mm:ss
hh:mm:ss
hh:mm:ss YYYY-MM-DD - ANSWER-hh:mm:ss
12. Which MySQL operator is the last in the order of operator precedence?
-
OR
NOT
= - ANSWER-OR
13. Which operator is used to compare columns from the left and right tables in
MySQL?
<=
+
=
* - ANSWER-=
14. Which type of join combines two tables without comparing columns?
SELF
EQUIJOIN
OUTER
CROSS - ANSWER-CROSS
15. Which type of join compares columns using only the = operator?
Equijoin
Non-equijoin
Outer join
Inner join - ANSWER-Equijoin
16. Which type of join is demonstrated by the following query?
, SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
NON-EQUIJOIN
SELF JOIN
CROSS JOIN
EQUIJOIN - ANSWER-EQUIJOIN
17. What is another name for a subquery?
Outer query
Nested query
Correlated query
Search query - ANSWER-Nested query
18. Which operator is used to compare against a list of values when determining a
match in a WHERE clause?
IN
BETWEEN
LIKE
OR - ANSWER-IN
19. Which wildcard character is used to represent zero or more characters when
searching for a specified pattern using a LIKE operator?
%
_
<
> - ANSWER-%
20. Which function is considered an aggregating function in SQL?
TRIM
REPLACE
MIN
SUBSTRING - ANSWER-MIN
21. Which clause or function is used with aggregate functions to produce summary
rows?
TRIM
REPLACE
ORDER BY
GROUP BY - ANSWER-GROUP BY
