Q1125
Which of the following belongs to an "aggregate function"?
A.
COUNT
B.
SUM/AVG
C.
MIN/MAX
D.
All of the mentioned
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
This question is asking about aggregate functions in MySQL. Aggregate functions are special functions that work on groups of rows to calculate a single value.
Let's look at the options:
Option A: COUNT
COUNT is used to count the number of rows in a table or the number of rows that meet a certain condition.
Option B: SUM/AVG
SUM adds up all the values in a column. AVG calculates the average of all values in a column.
Option C: MIN/MAX
MIN finds the smallest value in a column. MAX finds the largest value in a column.
Option D: All of the mentioned
Since COUNT, SUM, AVG, MIN, and MAX are all functions that work on groups of rows, the correct answer is All of the mentioned.