The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-061 — Oracle Database 12c: SQL Fundamentals

Question 5:

Which of the following statements about aggregate functions is correct?

A. All of the aggregate functions ignore NULL values.
B. If a query using aggregated functions has no GROUP BY clause, only a single row will be returned.
C. Aggregate functions cannot be nested.
D. Aggregate functions can appear only in the SELECT list and the ORDER BY clauses.
E. Aggregate functions can be used in any clause of a SELECT statement.