← Database Management System 🟡 Medium 📋 Sanfoundry

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

Question #1679 of 749+ in Database Management System

📝 Question #1679

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

⌨️ Press A B C D to select

All Options & Correct Answer

A To find the groups forming the subtotal in a row Correct
B To create group-wise grand totals for the groups specified within a GROUP BY clause
C To create a grouping for expressions or columns specified 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 specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals

📋 Question Details

🎯
Difficulty
Medium
📅
Year
📋
Source
Sanfoundry

📤 Share This MCQ

📚 Want More?

Practice Database Management System MCQs

749+ questions with detailed answers