COUNT, MAX, MIN, AVG and SUM are examples of which functions?
AAbsolute functions
BAssigned functions
CAggregate functions
DAdjacent functions
Answer & Solution
Correct answer: C. Aggregate functions
1. These five all condense many rows into one number.
2. Functions that behave that way share a name.
3. COUNT, MAX, MIN, AVG and SUM are given as examples of aggregate functions.
4. So the answer is aggregate functions.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.