WGU D662 Objective Assessment
Final with all 150 accurate and
verified questions covering data
analytics foundations, data
visualization, interpretation of
results, and ethical data use.
Guaranteed pass!!!.
CHECK (Constraint) <<<correct answer>>>The _______ constraint
specifies an expression on one or more columns of a table.
Adding and Dropping Constraints <<<correct answer>>>Constraints
are added and dropped with the ALTER TABLE TableName followed by
an ADD, DROP, or CHANGE clause.
BETWEEN (Operator) <<<correct answer>>>The ________ operator
provides an alternative way to determine if a value is between two
other values.
,LIKE (Operator) <<<correct answer>>>The _____ operator, when
used in a WHERE clause, matches text against a pattern using the two
wildcard characters % and _.
ORDER BY (Clause) <<<correct answer>>>The _____ ___ clause
orders selected rows by one or more columns in ascending (alphabetic
or increasing) order. The DESC keyword with the ORDER BY clause
orders rows in descending order.
ABS(n) (Function) <<<correct answer>>>Returns the absolute value
of n. Distance from zero. Always a positive number or zero.
LOWER(s) (Function) <<<correct answer>>>Returns the lowercase
"s". Or any specified characters.
TRIM(s) (Function) <<<correct answer>>>Returns the string "s"
without leading and trailing spaces
HOUR(t)
MINUTE(t)
SECOND(t)
(Function) <<<correct answer>>>Returns the hour, minute, or
second from time t
, Aggregate (Function) <<<correct answer>>>COUNT() counts the
number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
SUM() sums all the values in the set.
AVG() computes the arithmetic mean of all the values in the set.
HAVING (Clause) <<<correct answer>>>The HAVING clause is used
with the GROUP BY clause to filter group results.
JOIN <<<correct answer>>>A _____ is a SELECT statement that
combines data from two tables, known as the left table and right table,
into a single result. The tables are combined by comparing columns
from the left and right tables, usually with the = operator.
AS (Alias) <<<correct answer>>>A column name can be replaced
with an alias. The alias follows the column name, separated by an
optional AS keyword.
INNER JOIN <<<correct answer>>>Selects only matching left and
right table rows.
Final with all 150 accurate and
verified questions covering data
analytics foundations, data
visualization, interpretation of
results, and ethical data use.
Guaranteed pass!!!.
CHECK (Constraint) <<<correct answer>>>The _______ constraint
specifies an expression on one or more columns of a table.
Adding and Dropping Constraints <<<correct answer>>>Constraints
are added and dropped with the ALTER TABLE TableName followed by
an ADD, DROP, or CHANGE clause.
BETWEEN (Operator) <<<correct answer>>>The ________ operator
provides an alternative way to determine if a value is between two
other values.
,LIKE (Operator) <<<correct answer>>>The _____ operator, when
used in a WHERE clause, matches text against a pattern using the two
wildcard characters % and _.
ORDER BY (Clause) <<<correct answer>>>The _____ ___ clause
orders selected rows by one or more columns in ascending (alphabetic
or increasing) order. The DESC keyword with the ORDER BY clause
orders rows in descending order.
ABS(n) (Function) <<<correct answer>>>Returns the absolute value
of n. Distance from zero. Always a positive number or zero.
LOWER(s) (Function) <<<correct answer>>>Returns the lowercase
"s". Or any specified characters.
TRIM(s) (Function) <<<correct answer>>>Returns the string "s"
without leading and trailing spaces
HOUR(t)
MINUTE(t)
SECOND(t)
(Function) <<<correct answer>>>Returns the hour, minute, or
second from time t
, Aggregate (Function) <<<correct answer>>>COUNT() counts the
number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
SUM() sums all the values in the set.
AVG() computes the arithmetic mean of all the values in the set.
HAVING (Clause) <<<correct answer>>>The HAVING clause is used
with the GROUP BY clause to filter group results.
JOIN <<<correct answer>>>A _____ is a SELECT statement that
combines data from two tables, known as the left table and right table,
into a single result. The tables are combined by comparing columns
from the left and right tables, usually with the = operator.
AS (Alias) <<<correct answer>>>A column name can be replaced
with an alias. The alias follows the column name, separated by an
optional AS keyword.
INNER JOIN <<<correct answer>>>Selects only matching left and
right table rows.
