📚 Practice Mode

Database Concepts and SQL Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Choice

In which sceneria would you use the ROLLUP operator for expresiion or column with in a GROUPBY clause?

  1. To find the groups forming the subtotal in a row
  2. To create group-wise totals for the groups specified within a GROUPBY clause
  3. To create grouping for expressions or columns specified within a GROUPBY clause in one direction,from right to left for calculating the subtotals.
  4. To create grouping for expressions or columns specified within a GROUPBY clause in all possible direction,which is cross-tabular report for calculating the subtotals
Change Mode