Oracle
1Z0-007 · Question #114
Which two are true about aggregate functions? (Choose two.)
The correct answer is A. You can use aggregate functions in any clause of a SELECT statement. D. You can pass column names, expressions, constants, or functions as parameter to an aggregate function. See the full explanation below for the reasoning.
Question
Which two are true about aggregate functions? (Choose two.)
Options
- AYou can use aggregate functions in any clause of a SELECT statement.
- BYou can use aggregate functions only in the column list of the select clause and in the WHERE
- CYou can mix single row columns with aggregate functions in the column list of a SELECT statement
- DYou can pass column names, expressions, constants, or functions as parameter to an aggregate function.
- EYou can use aggregate functions on a table, only by grouping the whole table as one single group.
- FYou cannot group the rows of a table by more than one column while using aggregate functions.
How the community answered
(52 responses)- A83% (43)
- B2% (1)
- C2% (1)
- E6% (3)
- F8% (4)
Community Discussion
No community discussion yet for this question.