Exam 11: Group Functions

The ____________________ function is used to calculate the total amount stored in a numeric field for a group of records.

If the data returned by the GROUP BY clause needs to be sorted in descending order, you must include a(n) ____________________ clause in the SELECT statement.

If the DISTINCT keyword is not included in the AVG function, the ____ keyword will be assumed.

The only group function that includes NULL values is the $\underline { \text { NVL } }$ function. _________________________

Group functions return a group of results per row processed.

The SUM function can only be used with ____________________ columns.

Group functions can be nested to a depth of ____.

The default keyword for group functions is ____.

If the DISTINCT keyword is not included in the SUM function, the ____ keyword will be assumed.

When the SELECT statement includes both WHERE and GROUP BY clauses, the GROUP BY clause is always evaluated first.

The STDDEV function can be used with ____ columns.

The ____ function can be used to determine the number of rows meeting a specific condition.

The ____ function is used to determine how widely data are spread out within a group.

The ____________________ clause is used to restrict the groups returned by a query.

The $\underline {\text { 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. _________________________

The ____ function is used to calculate the total amount stored in a numeric field.

Explain the difference between a WHERE and a HAVING clause.

The AVG function can be used with ____ values.

The MAX function can only be used with numeric or date columns.

If the DISTINCT keyword is not included in the STDDEV function, the ____ keyword will be assumed.