nerdexam
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)
  • A
    6% (2)
  • B
    3% (1)
  • C
    74% (26)
  • D
    17% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice