MySQL Class 12 Quiz-8

Q71. Aggregate functions are also called ____________________

Q72. Aggregate functions return ___________ value for each column of the records on which the function is applied.

Q73. Which of the following functions returns one result per row?

Q74. Identify the odd one out.

Q75. Which of the following is Multiple row function?

Q76. _______________ functions returns the largest value from the specified column.

Q77. _______________ functions returns the smallest value from the specified column.

Q78. Which function returns the sum of the values for the specified column?

Q79. ________________ function returns the number of records in a table.

Q80. Consider the following column of table "employee"

Salary
10000
15000
25000
10000
NULL

What would be the output of the following query?

Select Avg(Salary) from employee;