Which of the following belongs to an "aggregate function"?
A. COUNT
B. SUM/AVG
C. MIN/MAX
D. All of the mentioned
Answer: Option D
Solution (By Examveda Team)
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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion