Oracle
1Z0-047 · Question #158
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. 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,
- Dto create a grouping for expressions or columns specified within a GROUP BY clause in all possible
How the community answered
(35 responses)- A6% (2)
- B3% (1)
- C74% (26)
- D17% (6)
Community Discussion
No community discussion yet for this question.