WGU Data Management - Foundations - D426

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