Congratulations! 🎉 You have reached the final lesson of the MySQL tutorial. This quiz tests important concepts covered throughout the complete 60-lesson MySQL course.
Instructions: Select the correct answer for each question and click Submit Final Quiz at the end. Your score will be displayed automatically.
1. What is MySQL?
2. Which command creates a database?
3. Which command selects a database for use?
4. Which command displays available databases?
5. Which command removes a database?
6. Which command creates a table?
7. Which statement adds new records to a table?
8. Which statement retrieves data?
9. Which clause filters rows?
10. Which operator requires both conditions to be true?
11. Which operator reverses a condition?
12. Which operator checks whether a value is within a range?
13. Which operator checks values against a list?
14. Which operator is commonly used for pattern matching?
15. Which symbol represents any sequence of characters with LIKE?
16. Which value represents missing or unknown data in SQL?
17. Which clause sorts query results?
18. Which keyword sorts values from highest to lowest?
19. Which clause limits the number of returned rows?
20. Which statement modifies existing records?
21. Which statement removes selected rows from a table?
22. Which statement changes the structure of a table?
23. Which command removes all rows while keeping the table structure?
24. Which key uniquely identifies each row?
25. What does a FOREIGN KEY mainly do?
26. Which constraint prevents NULL values?
27. Which constraint provides a value when no value is supplied?
28. Which feature automatically generates sequential numeric values?
29. Which function returns the length of a string?
30. Which function converts text to uppercase?
31. Which function returns the current date?
32. Which function calculates the difference between dates in days?
33. Which aggregate function counts rows?
34. Which function calculates the total of numeric values?
35. Which clause creates groups of rows?
36. Which clause filters grouped results?
37. Which JOIN returns matching rows from both tables?
38. Which JOIN keeps all rows from the left table?
39. What is a self join?
40. What is a subquery?
41. Which operator is commonly used with a subquery returning multiple values?
42. What does UNION do?
43. What is the main difference between UNION and UNION ALL?
44. What is a MySQL View?
45. Which command creates a View?
46. Which statement creates an ordinary index?
47. Which statement shows indexes on a table?
48. What is the main purpose of an index?
49. Which command starts an explicit transaction?
50. Which command permanently completes a transaction?
51. Which command cancels uncommitted transaction changes?
52. Which command creates a point inside a transaction?
53. What is a stored procedure?
54. Which command executes a stored procedure?
55. Which parameter type receives a value from the caller?
56. What is a MySQL Trigger?
57. Which keyword refers to new row values in an INSERT trigger?
58. Which keyword refers to the previous row values in a DELETE trigger?
59. Which storage engine commonly supports MySQL transactions?
60. Which MySQL feature automatically executes SQL when a specified table event occurs?