WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA ACTUAL EXAM 2
QUESTIONS WITH VERIFIED CORRECT
ANSWERS ALREADY GRADED A+ LATEST
VERSION 2025
11. 11. Which format is used by the TIME data type in MySQL?
YYYY-MM-DD
YYYY-MM-DD hh:mm:sshh:mm:ss
hh:mm:ss YYYY-MM-DD--- correct answer --- hh:mm:ss
12. 12. Which MySQL operator is the last in the order of operator
precedence?
-
OR
NOT
,=--- correct answer --- OR
13. 13. Which operator is used to compare columns from the left and
right tables in MySQL?
<=
+
=
*--- correct answer --- =
14. 14. Which type of join combines two tables without comparing
columns?
SELF
EQUIJOIN
OUTER
CROSS--- correct answer --- CROSS
, 15. 15. Which type of join compares columns using only the =
operator?
Equijoin
Non-equijoin
Outer join
Inner join--- correct answer --- Equijoin
16. 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--- correct answer --- EQUIJOIN
FOUNDATIONS OA ACTUAL EXAM 2
QUESTIONS WITH VERIFIED CORRECT
ANSWERS ALREADY GRADED A+ LATEST
VERSION 2025
11. 11. Which format is used by the TIME data type in MySQL?
YYYY-MM-DD
YYYY-MM-DD hh:mm:sshh:mm:ss
hh:mm:ss YYYY-MM-DD--- correct answer --- hh:mm:ss
12. 12. Which MySQL operator is the last in the order of operator
precedence?
-
OR
NOT
,=--- correct answer --- OR
13. 13. Which operator is used to compare columns from the left and
right tables in MySQL?
<=
+
=
*--- correct answer --- =
14. 14. Which type of join combines two tables without comparing
columns?
SELF
EQUIJOIN
OUTER
CROSS--- correct answer --- CROSS
, 15. 15. Which type of join compares columns using only the =
operator?
Equijoin
Non-equijoin
Outer join
Inner join--- correct answer --- Equijoin
16. 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--- correct answer --- EQUIJOIN
