Multiple choice technology databases

Which of these operators is used to calculate super aggregate results?

  1. ROLLUP

  2. COUNT

  3. AVG

  4. SUM

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ROLLUP generates subtotals (super-aggregates) at each hierarchy level in a GROUP BY operation. COUNT, AVG, and SUM are standard aggregate functions that produce single values per group, not hierarchical results.