MySQL – SELECT Statements MCQ

MySQL – SELECT Statements MCQ

1 / 26

1. What is the primary purpose of the SELECT statement in MySQL?

2 / 26

2. Which clause is used to specify the columns you want to retrieve in a SELECT statement?

3 / 26

3. What symbol is used to select all columns from a table in a SELECT statement?

4 / 26

4. What clause allows you to filter rows in a SELECT statement based on specific conditions?

5 / 26

5. How can you sort the result set of a SELECT statement in ascending order of a column?

6 / 26

6. Which SQL clause is used to group rows in a SELECT statement based on column values?

7 / 26

7. What aggregate function calculates the average of values in a column in a SELECT statement?

8 / 26

8. What is the purpose of the HAVING clause in a SELECT statement with GROUP BY?

9 / 26

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

10 / 26

10. What type of JOIN returns only the rows with matching values in both tables?

11 / 26

11. What does the LEFT JOIN operation return when there is no match on the right side?

12 / 26

12. What is the primary purpose of using the DISTINCT keyword in a SELECT statement?

13 / 26

13. How can you limit the number of rows returned by a SELECT statement in MySQL?

14 / 26

14. Which SQL clause allows you to create an alias for a column or table in a SELECT statement?

15 / 26

15. In a SELECT statement, what is the purpose of the WHERE clause?

16 / 26

16. What function calculates the total number of rows in a result set in a SELECT statement?

17 / 26

17. In a SELECT statement, what does the GROUP BY clause do?

18 / 26

18. Which SQL clause is used to specify conditions for grouped rows in a SELECT statement?

19 / 26

19. What type of JOIN returns all rows from both tables, including unmatched rows?

20 / 26

20. In a SELECT statement with GROUP BY, when is the HAVING clause applied?

21 / 26

21. What SQL clause is used to sort the result set of a SELECT statement?

22 / 26

22. How can you calculate the total sum of a numeric column in a SELECT statement?

23 / 26

23. Which SQL clause allows you to specify conditions for filtering rows in a SELECT statement?

24 / 26

24. What aggregate function counts the number of rows in a result set in a SELECT statement?

25 / 26

25. What is the primary purpose of using aliases in a SELECT statement?

26 / 26

26. What clause is used to specify the conditions for filtering rows in a SELECT statement?

Your score is

0%