Multiple choice technology databases

what are the functions used for calculating sub totals ?

  1. Using Rollup() function

  2. Using SUBTOT() function

  3. Using SUBSUM() function

  4. All the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Rollup function is the standard method for calculating subtotals and aggregated values in data analysis tools, databases (especially MongoDB with $rollup), and spreadsheet applications. While other functions like SUBTOTAL exist, Rollup is the most widely applicable approach for hierarchical aggregation. Option D cannot be correct since SUBTOT and SUBSUM are not standard function names.

Keep practicing — related questions