MySQL - Filtering and Sorting Data MCQ

MySQL – Filtering and Sorting Data MCQ

1 / 25

1. What SQL clause allows you to filter rows in a MySQL query?

FROM

SELECT

WHERE

ORDER BY

2 / 25

2. Which operator is commonly used in the WHERE clause to filter data based on conditions?

AND

% (percent sign)

LIKE

_ (underscore)

3 / 25

3. In MySQL, how do you sort query results in descending order?

SORT DESC

ORDER BY DESC

ASC

DESC

4 / 25

4. Which SQL clause is used for organizing data in a specific order in MySQL?

GROUP BY

ORDER BY

ARRANGE BY

SORT BY

5 / 25

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

To sort data

To select columns

To filter rows after grouping

To filter rows before grouping

6 / 25

6. How can you select rows where a specific column contains a partial match in MySQL?

Using % (percent sign)

Using = operator

Using _ (underscore)

Using LIKE operator

7 / 25

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

? (question mark)

* (asterisk)

% (percent sign)

_ (underscore)

8 / 25

8. What operator is used in MySQL to check if a column contains a NULL value in a query?

NULL

IS NOT NULL

IS NULL

NOT NULL

9 / 25

9. Which SQL clause is used to retrieve rows with NULL values in a column in MySQL?

NULL

NOT NULL

WHERE IS NOT NULL

WHERE IS NULL

10 / 25

10. How can you limit the number of rows returned by a MySQL query?

OFFSET

PAGE

MAX ROWS

LIMIT

11 / 25

11. In a MySQL query, what does the GROUP BY clause primarily do?

Sort data

Arrange rows

Group rows

Filter rows

12 / 25

12. What SQL operator is used to create complex conditions in the WHERE clause in MySQL?

OR

BOTH

NOT

AND

13 / 25

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

AVG

COUNT

SUM

MAX

14 / 25

14. What is the primary purpose of using subqueries in MySQL queries?

To embed one query within another

To filter rows before grouping

To simplify queries

To group rows

15 / 25

15. Which JOIN operation returns only the rows with matching values in both tables?

FULL JOIN

LEFT JOIN

INNER JOIN

RIGHT JOIN

16 / 25

16. In a MySQL query, which clause allows you to filter rows based on the result of a subquery?

JOIN

WHERE

HAVING

GROUP BY

17 / 25

17. What is the primary role of the ORDER BY clause in MySQL queries?

Aggregating data

Filtering data

Grouping data

Sorting data

18 / 25

18. What does the % wildcard character match in a MySQL LIKE query?

Any sequence of characters

Column names

NULL values

Any single character

19 / 25

19. What is the purpose of the LIMIT clause in a MySQL query?

To calculate averages

To filter rows

To limit the number of rows returned

To sort data

20 / 25

20. Which SQL operator is used to negate a condition in the WHERE clause?

OR

XOR

NOT

AND

21 / 25

21. In a MySQL query, how can you retrieve rows where a specific column does not contain NULL?

WHERE NULL

WHERE IS NULL

WHERE NOT NULL

WHERE NULL IS NOT

22 / 25

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

To sort data

To filter rows before grouping

To filter groups after grouping

To select columns

23 / 25

23. In a MySQL query, what happens if you don’t use the ORDER BY clause for sorting data?

The data is not sorted

The data is sorted in ascending order

An error occurs

The data is sorted in descending order

24 / 25

24. What SQL clause is used to group rows based on column values in MySQL?

SELECT

GROUP

GROUP BY

WHERE

25 / 25

25. What is the primary 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

Your score is

0%