Which statement is true about aggregate functions?
A. Aggregate functions can be nested to any number of levels
B. The AVG function implicitly converts NULLS to zero
C. Aggregate functions can be used in any clause of a SELECT statement
D. The MAX and MIN functions can be used on columns with character data types
D
The MAX and MIN functions can be used on columns with character data types’
D is correct
ORACLE throws this error with 3 or more nested functions ORA-00935: group function is nested too deeply