Oracle
1Z0-047 · Question #48
Which two statements are true about the GROUPING function? (Choose two.)
The correct answer is A. Itis 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
- AItis 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
(40 responses)- A85% (34)
- B5% (2)
- C10% (4)
Community Discussion
No community discussion yet for this question.