Multiple choice technology databases

Identify the OLAP function from the given options

  1. MSUM

  2. SUM

  3. AVG

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

MSUM (Moving Sum) is a Teradata-specific OLAP/window function used to calculate moving aggregations. Standard aggregates like SUM and AVG are basic SQL aggregation functions rather than dedicated moving or cumulative OLAP functions, making MSUM the correct choice.

Keep practicing — related questions