Page |1
WGU C427 OBJECTIVE ASSESSMENT FINAL EXAM NEWEST
2025/2026 NEWEST ACTUAL EXAM WITH COMPLETE
QUESTIONS AND VERIFIED ANSWERS |ALREADY GRADED
A+|
Write an SQL query using the LOWER() function to convert the
BestMove column to lowercase from the Avatar table where ID is
3. - ANSWER-SELECT LOWER(BestMove)
FROM Avatar
WHERE ID = 3;
Write an SQL query using the SUBSTRING() function to extract
the substring from the BestMove column starting at position 7 with
length 6 from the Avatar table where ID is 4. - ANSWER-SELECT
SUBSTRING(BestMove, 7, 6)
FROM Avatar
WHERE ID = 4;
Write an SQL query using the REPLACE() function to replace 'Kn'
with 'Fr' in the Name column from the Avatar table where ID is 2. -
ANSWER-SELECT REPLACE(Name, 'Kn', 'Fr')
, Page |2
FROM Avatar
WHERE ID = 2;
List common date and time functions in SQL. - ANSWER-
CURDATE(): Returns the current date in 'YYYY-MM-DD' format.
CURTIME(): Returns the current time in 'HH:MM' format. NOW():
Returns the current date and time in 'YYYY-MM-DD HH:MM'
format. DATE(expr): Extracts the date from a date or datetime
expression. TIME(expr): Extracts the time from a date or datetime
expression. DAY(d): Returns the day from date d. MONTH(d):
Returns the month from date d. YEAR(d): Returns the year from
date d. HOUR(t): Returns the hour from time t. MINUTE(t):
Returns the minute from time t. SECOND(t): Returns the second
from time t. DATEDIFF(expr1, expr2): Returns expr1 - expr2 in
number of days. TIMEDIFF(expr1, expr2): Returns expr1 - expr2
in time values.
Write an SQL query using the YEAR() and MONTH() functions to
select movies released after 2017 or in November from the Movie
table. - ANSWER-SELECT *
FROM Movie
, Page |3
WHERE YEAR(ReleaseDate) > 2017 OR MONTH(ReleaseDate)
= 11;
Write an SQL query using the TIME() function to extract the time
from the Due column from the Assignment table where ID is 2. -
ANSWER-SELECT TIME(Due)
FROM Assignment
WHERE ID = 2;
Write an SQL query using the DAY() function to extract the day
from the Due column from the Assignment table where ID is 4. -
ANSWER-SELECT DAY(Due)
FROM Assignment
WHERE ID = 4;
Write an SQL query using the HOUR() and MINUTE() functions to
sum the hour and minute from the Assigned column from the
Assignment table where ID is 2. - ANSWER-SELECT
HOUR(Assigned) + MINUTE(Assigned)
FROM Assignment
, Page |4
WHERE ID = 2;
Write an SQL query using the DATEDIFF() function to find the
difference in days between Due and Assigned columns from the
Assignment table where ID is 1. - ANSWER-SELECT
DATEDIFF(Due, Assigned)
FROM Assignment
WHERE ID = 1;
Write an SQL query using the TIMEDIFF() function to find the time
difference between Due and Assigned columns from the
Assignment table where ID is 3. - ANSWER-SELECT
TIMEDIFF(Due, Assigned)
FROM Assignment
WHERE ID = 3;
What are aggregate functions in SQL? - ANSWER-Aggregate
functions process values from a set of rows and return a summary
value. Common aggregate functions include COUNT(), MIN(),
MAX(), SUM(), and AVG.
WGU C427 OBJECTIVE ASSESSMENT FINAL EXAM NEWEST
2025/2026 NEWEST ACTUAL EXAM WITH COMPLETE
QUESTIONS AND VERIFIED ANSWERS |ALREADY GRADED
A+|
Write an SQL query using the LOWER() function to convert the
BestMove column to lowercase from the Avatar table where ID is
3. - ANSWER-SELECT LOWER(BestMove)
FROM Avatar
WHERE ID = 3;
Write an SQL query using the SUBSTRING() function to extract
the substring from the BestMove column starting at position 7 with
length 6 from the Avatar table where ID is 4. - ANSWER-SELECT
SUBSTRING(BestMove, 7, 6)
FROM Avatar
WHERE ID = 4;
Write an SQL query using the REPLACE() function to replace 'Kn'
with 'Fr' in the Name column from the Avatar table where ID is 2. -
ANSWER-SELECT REPLACE(Name, 'Kn', 'Fr')
, Page |2
FROM Avatar
WHERE ID = 2;
List common date and time functions in SQL. - ANSWER-
CURDATE(): Returns the current date in 'YYYY-MM-DD' format.
CURTIME(): Returns the current time in 'HH:MM' format. NOW():
Returns the current date and time in 'YYYY-MM-DD HH:MM'
format. DATE(expr): Extracts the date from a date or datetime
expression. TIME(expr): Extracts the time from a date or datetime
expression. DAY(d): Returns the day from date d. MONTH(d):
Returns the month from date d. YEAR(d): Returns the year from
date d. HOUR(t): Returns the hour from time t. MINUTE(t):
Returns the minute from time t. SECOND(t): Returns the second
from time t. DATEDIFF(expr1, expr2): Returns expr1 - expr2 in
number of days. TIMEDIFF(expr1, expr2): Returns expr1 - expr2
in time values.
Write an SQL query using the YEAR() and MONTH() functions to
select movies released after 2017 or in November from the Movie
table. - ANSWER-SELECT *
FROM Movie
, Page |3
WHERE YEAR(ReleaseDate) > 2017 OR MONTH(ReleaseDate)
= 11;
Write an SQL query using the TIME() function to extract the time
from the Due column from the Assignment table where ID is 2. -
ANSWER-SELECT TIME(Due)
FROM Assignment
WHERE ID = 2;
Write an SQL query using the DAY() function to extract the day
from the Due column from the Assignment table where ID is 4. -
ANSWER-SELECT DAY(Due)
FROM Assignment
WHERE ID = 4;
Write an SQL query using the HOUR() and MINUTE() functions to
sum the hour and minute from the Assigned column from the
Assignment table where ID is 2. - ANSWER-SELECT
HOUR(Assigned) + MINUTE(Assigned)
FROM Assignment
, Page |4
WHERE ID = 2;
Write an SQL query using the DATEDIFF() function to find the
difference in days between Due and Assigned columns from the
Assignment table where ID is 1. - ANSWER-SELECT
DATEDIFF(Due, Assigned)
FROM Assignment
WHERE ID = 1;
Write an SQL query using the TIMEDIFF() function to find the time
difference between Due and Assigned columns from the
Assignment table where ID is 3. - ANSWER-SELECT
TIMEDIFF(Due, Assigned)
FROM Assignment
WHERE ID = 3;
What are aggregate functions in SQL? - ANSWER-Aggregate
functions process values from a set of rows and return a summary
value. Common aggregate functions include COUNT(), MIN(),
MAX(), SUM(), and AVG.
