In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Question

TuteeHUB · Accepted Answer

to create a grouping for expressions or columns speciï¬ed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

TuteeHUB · Answer

to ï¬nd the groups forming the subtotal in a row

TuteeHUB · Answer

to create group-wise grand totals for the groups speciï¬ed within a group by clause

TuteeHUB · Answer

to create a grouping for expressions or columns speciï¬ed within a group by clause in one direction, from right to left for calculating the subtotals

TuteeHUB · Answer

to create a grouping for expressions or columns speciï¬ed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

1.	In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
A.	to ï¬nd the groups forming the subtotal in a row
B.	to create group-wise grand totals for the groups speciï¬ed within a group by clause
C.	to create a grouping for expressions or columns speciï¬ed within a group by clause in one direction, from right to left for calculating the subtotals
D.	to create a grouping for expressions or columns speciï¬ed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals
Answer» D. to create a grouping for expressions or columns speciï¬ed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Discussion

No Comment Found

Related MCQs

Reply to Comment