Oracle
1Z0-047 · Question #109
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
The correct answer is C. to create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from. See the full explanation below for the reasoning.
Question
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
Options
- Ato find the groups forming the subtotal in a row
- Bto create group-wise grand totals for the groups specified within a GROUP BY clause
- Cto create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from
- Dto create a grouping for expressions or columns specified within a GROUP BY clause in all possible
How the community answered
(37 responses)- A5% (2)
- B11% (4)
- C81% (30)
- D3% (1)
Community Discussion
No community discussion yet for this question.