Multiple choice technology databases

Which are the aggregate functions?

  1. SUM

  2. AVG

  3. trim

  4. median
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

Aggregate functions perform calculations on multiple values and return a single result. SUM and AVG are standard SQL aggregate functions. Median is also an aggregate function (though not available in all SQL dialects). Trim is a string manipulation function that operates on individual values, not sets.

Keep practicing — related questions