Lesson 12: Practice Exercises

40 min test Beginner–Intermediate Final Lesson 8.9k learners

Final SQL Basics Quiz

This final exercise contains 20 questions covering everything from Lesson 1 to 11. Try to complete it without peeking back! 🎯

1. Which of the following is the correct definition of SQL?
2. Which type of database model does SQL primarily interact with?
3. Which SQL keyword retrieves data?
4. What does SELECT * mean?
5. Which clause is used to filter rows?
6. Which operator checks for a range of values?
7. Which keyword sorts query results?
8. What is the default sort order?
9. Which function returns the number of rows?
10. Which function finds the highest value?
11. Which clause groups rows?
12. Which clause filters groups (after aggregation)?
13. Which join returns only matching rows in both tables?
14. Which join keeps all rows from the left table?
15. What is a subquery?
16. Which keyword is often used with subqueries?
17. Which statement adds new rows?
18. Which is valid syntax?
19. Which statement modifies existing data?
20. Which statement removes rows from a table?