1. What is the purpose of the MySQL "ERROR" log file?
2. What is the purpose of the SQL GROUP BY clause?
3. What does the "MySQL Query Cache" do and why might it cause issues?
4. Which privilege allows a user to read data from a MySQL database?
5. In MySQL, which SQL command can be used to remove an index from a table?
6. MySQL is an open-source ________ database management system.
7. Which data type is used for storing fixed-length character strings?
8. Which SQL statement is used to insert data into a MySQL table?
9. What feature of MySQL Workbench allows you to visualize the structure of a database schema?
10. What is the purpose of the binary log in MySQL replication?
11. What is the primary purpose of the MySQL "Slow Query Log"?
12. What is a physical backup in MySQL?
13. Which SQL clause is used to filter the results of a SELECT query in MySQL?
14. What SQL statement is used to remove data from a database?
15. What is the primary purpose of user authentication in MySQL?
16. Which data type is used to store large binary data, such as images or documents?
17. What is the primary purpose of database backups in MySQL?
18. What is the purpose of the MySQL option file (my.cnf or my.ini)?
19. In MySQL, what is the purpose of binary log files?
20. What is the primary advantage of using the "Replication" method for database migration in MySQL?