MySQL quiz

Test your MySQL knowledge with a free interactive quiz — 50 questions with answers and explanations. No signup needed to play.

What does `JOIN` do in SQL?

1. What does `JOIN` do in SQL?
2. Which statement creates a new database?
3. How is `NULL` handled in equality comparisons?
4. What clause limits the number of rows returned?
5. Which clause filters rows in a `SELECT` query?
6. Which data type would you use for a true/false flag?
7. How do you add a new column to an existing table?
8. How do you start a transaction in MySQL?
9. What does a `LEFT JOIN` return?
10. What is the purpose of an index in MySQL?
11. What is MySQL?
12. Which SQL statement retrieves rows from a table?

More quizzes