MySQL - Grouping Data with GROUP BY MCQ

MySQL – Grouping Data with GROUP BY MCQ

1 / 25

1. What is the primary purpose of the GROUP BY clause in MySQL?

To filter data

To organize and aggregate data

To select columns

To sort data

2 / 25

2. In MySQL, what does the GROUP BY clause do when used with the SELECT statement?

Filters rows based on conditions

Calculates averages

Groups rows based on column values

Sorts data

3 / 25

3. How is data organized with the GROUP BY clause in MySQL?

Into aggregated groups

Alphabetically by column name

In descending order

In ascending order

4 / 25

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

Sort data

Filter rows before grouping

Filter groups after grouping

Perform calculations on columns

5 / 25

5. Which aggregate function calculates the total sales amount for each product category?

COUNT()

AVG()

SUM()

MIN()

6 / 25

6. When using GROUP BY in MySQL, what does the SUM() function do?

Filters rows based on conditions

Sorts data

Calculates the average

Groups data and calculates the sum

7 / 25

7. What does the HAVING clause in MySQL allow you to filter in GROUP BY queries?

Sorting criteria

Individual rows

Aggregated groups

Column names

8 / 25

8. In a GROUP BY query, what does the COUNT() function typically calculate?

The total number of rows

The minimum value

The average

The maximum value

9 / 25

9. How can you use GROUP BY to group data based on multiple columns in MySQL?

By listing the columns within GROUP BY

By specifying multiple GROUP BY clauses

By using the COUNT() function

By using the ORDER BY clause

10 / 25

10. What is the purpose of the HAVING clause in MySQL when used with GROUP BY?

To filter rows based on conditions

To group data

To calculate averages

To sort data

11 / 25

11. What happens if you don’t use the GROUP BY clause with an aggregate function in MySQL?

The data is not grouped

An error occurs

The data is filtered

The data is not sorted

12 / 25

12. In MySQL, which clause is used to filter grouped data after using GROUP BY?

HAVING clause

LIMIT clause

WHERE clause

ORDER BY clause

13 / 25

13. Which SQL clause allows you to calculate the total sales amount for each product category?

HAVING

ORDER BY

SELECT

GROUP BY

14 / 25

14. What is the primary purpose of using aliases in a GROUP BY query?

To reduce the number of columns

To filter rows based on conditions

To provide alternative names for columns

To create temporary tables

15 / 25

15. In MySQL, what does the COUNT() function return when used without any column specified?

The sum of all values

The maximum value

The average value

The total number of rows

16 / 25

16. How can you sort the result of a GROUP BY query in MySQL?

By using the WHERE clause

By using the GROUP BY clause

By using the ORDER BY clause

By using the HAVING clause

17 / 25

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

MAX()

COUNT()

SUM()

AVG()

18 / 25

18. What SQL clause is used for filtering rows in a MySQL query?

WHERE

SELECT

GROUP BY

HAVING

19 / 25

19. What is the primary purpose of using subqueries with GROUP BY in MySQL?

To filter rows before grouping

To create new tables

To simplify queries

To embed one query within another

20 / 25

20. In a MySQL query, what does the GROUP BY clause affect?

The order of columns in the result set

The number of rows returned

Sorting criteria

The grouping of rows

21 / 25

21. Which aggregate function calculates the maximum value in a column in MySQL?

MIN()

COUNT()

MAX()

AVG()

22 / 25

22. What does the GROUP BY clause do when used with aggregate functions in MySQL?

Filters data

Groups data

Sorts data

Aggregates data

23 / 25

23. In a GROUP BY query, what is typically used to categorize and group data?

The GROUP BY clause

The HAVING clause

The ORDER BY clause

The WHERE clause

24 / 25

24. Which SQL clause allows you to perform calculations on columns in MySQL?

GROUP BY

SELECT

HAVING

CALCULATE

25 / 25

25. What does the GROUP BY clause help achieve in MySQL?

Sorting data

Grouping data

Filtering data

Calculating averages

Your score is