MCQ King
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
Restart quiz