Test your knowledge of SQL concepts covered throughout the complete SQL tutorial. This final quiz includes questions from basic SQL syntax, filtering, constraints, functions, joins, subqueries, views, indexes, transactions, stored procedures, and practical SQL.
Note: Read each question carefully and select the correct answer. There are 30 questions in this final quiz.
1. What does SQL stand for?
2. Which SQL statement is used to retrieve data?
3. Which clause filters records in a SELECT query?
4. Which keyword removes duplicate rows from a SELECT result?
5. Which operator is used to check whether a value is within a range?
6. Which operator is used to search for a pattern in text?
7. Which operator represents NULL in a condition?
8. Which clause sorts the result of a query?
9. Which statement is used to modify existing records?
10. Which statement removes selected records from a table?
11. Which statement changes the structure of an existing table?
12. Which command removes a table completely?
13. Which command removes all rows while keeping the table structure?
14. Which constraint uniquely identifies each record?
15. Which constraint creates a relationship between tables?
16. Which constraint prevents NULL values?
17. Which function calculates the total of numeric values?
18. Which clause groups rows having the same values?
19. Which clause filters grouped results?
20. Which JOIN returns matching records from both tables?
21. Which JOIN returns all records from the left table?
22. What is a subquery?
23. Which operator combines SELECT results and removes duplicates?
24. Which operator keeps duplicate rows when combining SELECT results?
25. What is a SQL View?
26. What is the main purpose of an index?
27. Which command permanently saves transaction changes?
28. Which command cancels uncommitted transaction changes?
29. Which command executes a stored procedure in MySQL?
30. Which SQL feature is used to store reusable SQL operations in the database?