Oracle
1Z0-047 · Question #133
Which statement best describes the GROUPING function?
The correct answer is C. It is used to identify if the NULL value in an expression is a stored NULL value or created by ROLLUP. See the full explanation below for the reasoning.
Question
Which statement best describes the GROUPING function?
Options
- AIt is used to set the order for the groups to be used for calculating the grand totals and subtotals.
- BIt is used to form various groups to calculate total and subtotals created using ROLLUP and CUBE
- CIt is used to identify if the NULL value in an expression is a stored NULL value or created by ROLLUP
- DIt is used to specify the concatenated group expressions to be used for calculating the grand totals
How the community answered
(50 responses)- A12% (6)
- B2% (1)
- C80% (40)
- D6% (3)
Community Discussion
No community discussion yet for this question.