Vidyalelo
MySQL · Q136

MySQL

Programming · MySQL · question 136

Q136

Which among the following belongs to an "aggregate function"?

A.
COUNT
Answer
B.
UPPER
C.
LOWER
D.
All of the mentioned

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about aggregate functions in MySQL. Aggregate functions are special functions that work with groups of rows in your database table. They summarize data to give you a single value for each group.
Let's look at the options:
Option A: COUNT
This function counts the number of rows in a table or a specific column. It's an aggregate function because it combines multiple rows into a single count value.
Option B: UPPER
This function converts all the letters in a string to uppercase. It's not an aggregate function because it works on individual values within a single row, not on groups of rows.
Option C: LOWER
Similar to UPPER, this function converts all the letters in a string to lowercase. It also works on individual values and is not an aggregate function.
Option D: All of the mentioned
This option is incorrect because only COUNT is an aggregate function.
Therefore, the correct answer is Option A: COUNT.