MySQL Aggregate Functions Quiz

Which of the following is NOT an aggregate function in MySQL?

• COUNT()

• AVG()

• SUM()

• ROUND()

The function used to find the total of values in a numeric column is:

• MAX()

• TOTAL()

• SUM()

• COUNT()

Which aggregate function returns the number of rows in a table or result set?

• SUM()

• AVG()

• COUNT()

• LENGTH()

Which function returns the largest value in a column?

• MAX()

• UPPER()

• BIGGEST()

• LARGE()

The function used to find the smallest value from a column is:

• LOWER()

• SMALL()

• MIN()

• LEAST()

The AVG() function in MySQL is used to:

• Add all numeric values

• Find average of numeric values

• Find total number of rows

• Return distinct values

Which of the following SQL statements will display the total salary from the ‘Employee’ table?

• SELECT TOTAL(salary) FROM Employee;

• SELECT SUM(salary) FROM Employee;

• SELECT COUNT(salary) FROM Employee;

• SELECT ADD(salary) FROM Employee;

The COUNT(*) function counts:

• Only numeric values

• Only non-null values

• All rows in the table

• Only unique values

What will COUNT(column_name) return?

• Total number of rows

• Number of non-null values in that column

• Number of null values in that column

• Average of values

Which of the following can be used with GROUP BY clause?

• Aggregate Functions

• Comparison Operators

• String Functions

• Logical Operators