Which statement is true about aggregate functions?
A. The AVG function implicitly converts NULLS to zero.
B. Aggregate functions can be nested to any number of levels.
C. The MAX and MIN functions can be used on columns with character data types.
D. Aggregate functions can be used in any clause of a SELECT statement.
C
CD
sorry, only C
C is correct answer
CORRECT ANSWER: C
MAX and MIN operate on columns that contain character, graphic, numeric, date/time, and binary data (except for binary large object, or BLOB, data).
A) AVG() function ignores NULL Values.
B) Two level deep
D) You can’t use an aggregate directly in a WHERE clause;
D
C