Which database function is used to calculate values such as COUNT, SUM and AVG?

Options

  • A. Aggregate functions
  • B. String functions
  • C. Date formatting functions
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Aggregate functions

Detailed Explanation

  • Aggregate functions: Perform calculations on a set of rows and return a single result.
  • COUNT(): Counts rows or non-NULL values.
  • SUM(): Calculates the total of numeric values.
  • AVG(): Calculates the average of numeric values.