Oracle
1Z0-071 · Question #8
Which three statements are true regarding group functions? (Choose three.)
The correct answer is A. They can be used on columns or expressions. B. They can be passed as an argument to another group function. E. They can be used along with the single-row function in the SELECT clause of a SQL statement. See the full explanation below for the reasoning.
Question
Which three statements are true regarding group functions? (Choose three.)
Options
- AThey can be used on columns or expressions.
- BThey can be passed as an argument to another group function.
- CThey can be used only with a SQL statement that has the GROUP BY clause.
- DThey can be used on only one column in the SELECT clause of a SQL statement.
- EThey can be used along with the single-row function in the SELECT clause of a SQL statement.
How the community answered
(40 responses)- A80% (32)
- C8% (3)
- D13% (5)
Community Discussion
No community discussion yet for this question.