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

M

Mr. Dubey

🎓 Coach ⭐ 104.60K Points

📊 Database Management System (DBMS)

Q. 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

💬 Discuss

✅ Correct Answer: (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

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

237

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

95%

Success Rate