Oracle
1Z0-071 · Question #294
Which statement is true about aggregate functions?
The correct answer is B. Aggregate functions can be nested to any number of levels. https://docs.oracle.com/database/121/SQLRF/functions003.htm
Reporting Aggregated Data Using the Group Functions
Question
Which statement is true about aggregate functions?
Options
- AThe AVG function implicitly converts NULLS to zero.
- BAggregate functions can be nested to any number of levels.
- CThe MAX and MIN functions can be used on columns with character data types.
- DAggregate functions can be used in any clause of a SELECT statement.
How the community answered
(51 responses)- A2% (1)
- B80% (41)
- C6% (3)
- D12% (6)
Explanation
Topics
#aggregate functions#AVG#MAX MIN#NULL handling
Community Discussion
No community discussion yet for this question.