The ____ function calculates the standard deviation for a specific set of data.
A) STDDEVIATION
B) STD
C) STDDEV
D) STANDARDDEV
Front
C) STDDEV
Back
The MAX function can be used with character data.
A) True
B) False
Front
A) True
Back
The SUM function can only be used with ____ data.
A) numeric
B) character
C) date
D) alphanumeric
Front
A) numeric
Back
If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.
A) HAVING
B) GROUP BY
C) WHERE
D) ORDER BY
Front
C) WHERE
Back
Functions that return one result per group of rows are called ____ functions.
A) group
B) multiple-row
C) aggregate
D) all of the above
Front
D) all of the above
Back
The HAVING clause specifies which groups will be displayed in the results, while the WHERE clause restricts the records that are retrieved from the table for processing.
A) True
B) False
Front
A) True
Back
A group function can be nested inside a(n)____.
A) group function
B) single-row function
C) order function
D) both a and b
Front
D) both a and b
Back
The ORDER BY clause is used to group data.
A) True
B) False
Front
B) False
Back
A(n) ____ clause cannot include a group function.
A) WHERE
B) HAVING
C) SELECT
D) both a and c
Front
A) WHERE
Back
Which of the following is a valid statement?
A) A single-row function can be nested inside a group function.
B) Group functions can be nested inside other group functions.
C) Group functions can be nested inside single-row functions.
D) all of the above