WGU D427 Chapter 2 exam questions fully solved & updated 2025

WGU D427 Chapter 2 exam
questions fully solved & updated
2025

IN - answer This operator is used in a WHERE
clause to determine if a value matches one of
several values.


BETWEEN - answer This operator provides an
alternative way to determine if a value is between
two other values. The operator is written value
________ minValue AND maxValue and is equivalent
to value >= minValue AND value <= maxValue.


LIKE - answer This operator, when used in a
WHERE clause, matches text against a pattern
using the two wildcard characters % and _.


BINARY - answer This operator performs case-
insensitive pattern matching by default or case-
sensitive pattern matching if followed by the
__________ keyword.


DISTINCT - answer This clause is used with a
SELECT statement to return only unique or _________
values.

, ORDER BY - answer This clause orders selected
rows by one or more columns in ascending
(alphabetic or increasing) order.


DESC - answer This keyword with the ORDER BY
clause orders rows in descending order.


function / argument - answer A function operates
on an expression enclosed in parentheses, called
an argument, and returns a value. Usually, the
argument is a simple expression, such as a column
name or fixed value. Some functions have several
arguments, separated by commas, and a few have
no arguments at all.


aggregate function - answer processes values
from a set of rows and returns a summary value.


COUNT() - answer counts the number of rows in
the set.


MIN() - answer finds the minimum value in the
set.


MAX() - answer finds the maximum value in the
set.