MySQL - Aggregate Functions (SUM, AVG, COUNT) MCQ

MySQL – Aggregate Functions (SUM AVG COUNT) MCQ

1 / 25

1. What do aggregate functions in MySQL do?

Group data

Create new tables

Perform calculations on multiple columns

Sort data

2 / 25

2. Which aggregate function calculates the sum of numeric values in a column?

SUM

AVG

COUNT

MIN

3 / 25

3. What does the AVG() function in MySQL calculate?

Maximum value

Minimum value

Total count of values

Average value

4 / 25

4. What does the COUNT() function in MySQL return when used with * (asterisk)?

Average value

Total number of rows

Sum of all values

Minimum value

5 / 25

5. Which aggregate function is used to count the number of non-null values in a column?

AVG

COUNT

SUM

MAX

6 / 25

6. How do you use the GROUP BY clause with aggregate functions in MySQL?

To filter rows based on conditions

To perform calculations on multiple columns

To group rows based on column values

To sort data

7 / 25

7. What does the MIN() function in MySQL retrieve from a column?

The average value

The smallest value

The maximum value

The total count of values

8 / 25

8. Which aggregate function is used to find the maximum value in a column in MySQL?

MAX

MIN

AVG

COUNT

9 / 25

9. What does the MAX() function return when used with a column containing only NULL values?

The minimum value

The maximum value

NULL

An error message

10 / 25

10. How can you filter grouped data in MySQL after using the GROUP BY clause?

By using the WHERE clause

By using the ORDER BY clause

By using the HAVING clause

By using the LIMIT clause

11 / 25

11. What does the HAVING clause in MySQL allow you to do when used with GROUP BY?

Group rows based on column values

Filter rows before grouping

Filter groups after grouping

Perform calculations on columns

12 / 25

12. Which aggregate function calculates the average of values in a column in MySQL?

COUNT

AVG

SUM

MIN

13 / 25

13. What is the primary purpose of using the HAVING clause in MySQL?

To filter rows before grouping

To filter rows after grouping

To select columns

To sort data

14 / 25

14. How can you calculate the total number of rows in a result set in MySQL?

Using SUM

Using AVG

Using MAX

Using COUNT

15 / 25

15. What is the primary purpose of using subqueries with aggregate functions in MySQL?

To filter rows before grouping

To embed one query within another

To create new tables

To simplify queries

16 / 25

16. Which JOIN operation combines rows from two or more tables based on a related column?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

17 / 25

17. In MySQL, what happens if you don’t use the GROUP BY clause with an aggregate function?

The data is not grouped

An error occurs

The data is filtered

The data is not sorted

18 / 25

18. Which SQL clause is used for sorting data in MySQL?

ORDER BY

GROUP BY

ARRANGE BY

FILTER BY

19 / 25

19. What is the purpose of using the LIKE operator in a MySQL query?

To filter rows

To sort data

To create subqueries

To filter rows based on patterns

20 / 25

20. Which wildcard character in MySQL matches any sequence of characters in a LIKE query?

* (asterisk)

_ (underscore)

? (question mark)

% (percent sign)

21 / 25

21. How do you limit the number of rows returned by a MySQL query?

Using the LIMIT clause

Using the OFFSET clause

Using the WHERE clause

Using the HAVING clause

22 / 25

22. In a MySQL query, how do you negate a condition in the WHERE clause?

Using AND

Using OR

Using XOR

Using NOT

23 / 25

23. Which SQL operator is used to create complex conditions in the WHERE clause in MySQL?

BOTH

AND

NOT

24 / 25

24. What is the primary purpose of using aliases in a MySQL query?

To reduce the number of columns

To provide alternative names for columns

To filter rows based on conditions

To create temporary tables

25 / 25

25. What clause is used to specify conditions for filtering rows in a MySQL query?

HAVING

WHERE

GROUP BY

SELECT

Your score is

MySQL – Aggregate Functions (SUM, AVG, COUNT) MCQ