Oracle
1Z0-082 · Question #20
Which statement is true about aggregate functions?
The correct answer is A. Aggregate functions can be nested to any number of levels. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which statement is true about aggregate functions?
Options
- AAggregate functions can be nested to any number of levels
- BThe AVG function implicitly converts NULLS to zero
- CAggregate functions can be used in any clause of a SELECT statement
- DThe MAX and MIN functions can be used on columns with character data types
How the community answered
(62 responses)- A73% (45)
- B5% (3)
- C15% (9)
- D8% (5)
Topics
#aggregate functions#nested aggregates#NULL handling#MAX MIN
Community Discussion
No community discussion yet for this question.