Oracle
1Z0-047 · Question #174
Which two statements are true about the GROUPING function? (Choose two.)
The correct answer is A. It is used to find the groups forming the subtotal in a row. D. It can only be used with ROLLUP and CUBE operators specified in the GROUP BY clause. See the full explanation below for the reasoning.
Question
Which two statements are true about the GROUPING function? (Choose two.)
Options
- AIt is used to find the groups forming the subtotal in a row.
- BIt is used to identify the NULL value in the aggregate functions.
- CIt is used to form the group sets involved in generating the totals and subtotals.
- DIt can only be used with ROLLUP and CUBE operators specified in the GROUP BY clause.
How the community answered
(34 responses)- A74% (25)
- B9% (3)
- C18% (6)
Community Discussion
No community discussion yet for this question.