MCQ King
MySQL – Joins (INNER LEFT RIGHT FULL) MCQ
1 / 25
1. What is the primary purpose of joins in MySQL?
2 / 25
2. Which type of join returns only the rows that have matching values in both tables?
3 / 25
3. When using INNER JOIN, what is the result when there are no matching values in one of the tables?
4 / 25
4. What is the primary purpose of using LEFT JOIN in MySQL?
5 / 25
5. In a LEFT JOIN, what values are returned for columns from the right table when there is no match?
6 / 25
6. Which type of join is used to retrieve all rows from the right table and matched rows from the left table?
7 / 25
7. What is the primary purpose of RIGHT JOIN in MySQL?
8 / 25
8. In a RIGHT JOIN, what values are returned for columns from the left table when there is no match?
9 / 25
9. Which type of join returns all rows when there is a match in either the left or the right table?
10 / 25
10. What is the purpose of using FULL JOIN in MySQL?
11 / 25
11. In a FULL JOIN, what values are returned for columns from tables that have no match?
12 / 25
12. Which type of join combines rows from two or more tables based on a related column?
13 / 25
13. In an INNER JOIN, what happens if you don’t specify a condition for the join?
14 / 25
14. What SQL clause allows you to create a unified dataset from multiple tables in MySQL?
15 / 25
15. Which type of join is used when you want to retrieve all rows from the left table and related data from the right table?
16 / 25
16. In a LEFT JOIN, what happens if you specify multiple conditions for the join?
17 / 25
17. What is the primary purpose of using aliases in MySQL joins?
18 / 25
18. Which type of join is less commonly used compared to INNER JOIN and LEFT JOIN in MySQL?
19 / 25
19. In a RIGHT JOIN, how do you specify the condition for the join in MySQL?
20 / 25
20. What SQL clause is used to specify conditions for filtering rows in MySQL joins?
21 / 25
21. What is the purpose of the ON clause in MySQL joins?
22 / 25
22. In a LEFT JOIN, which table is considered the “left” table?
23 / 25
23. What does the FULL JOIN return when there is a match in both tables?
24 / 25
24. Which type of join is used when you want to retrieve unmatched rows from both tables in MySQL?
25 / 25
25. In a FULL JOIN, what values are returned for columns from both tables when there is no match?
Your score is
Restart quiz