Which of the following are correct aggregate functions in SQL ?

1. AVERAGE()
2. MAX()
3. COUNT()
4. TOTAL()

Write the output of the following SQL command :

SELECT Round(49.88);

1. 49.88
2. 49.8
3. 49.0
4. 50

The avg() function in MySQL is an example of …………… .

1. Math function
2. Text function
3. Date Function
4. Aggregate Function

An aggregate function performs a calculation on …………… and returns a single value.

1. single value
2. multiple values
3. no value
4. none of these