25+ MySQL Interview Questions

MySQL Interview Questions:

1. What is MySQL?
2. What are the different types of joins in MySQL?
3. What is the difference between `INNER JOIN` and `OUTER JOIN`?
4. What is a primary key in MySQL?
5. What is a foreign key in MySQL?
6. What is normalization in MySQL?
7. What are the types of normalization?
8. Explain the `GROUP BY` clause in MySQL.
9. What is the use of `HAVING` clause in MySQL?
10. What is the difference between `WHERE` and `HAVING` in MySQL?
11. What is an `INDEX` in MySQL?
12. How do you create an index in MySQL?
13. What are the different types of indexes in MySQL?
14. What is a `VIEW` in MySQL?
15. How do you create and drop a view in MySQL?
16. What is the `AUTO_INCREMENT` attribute in MySQL?
17. What is the difference between `TRUNCATE` and `DELETE` in MySQL?
18. What is a `Stored Procedure` in MySQL?
19. What is a `Trigger` in MySQL?
20. What is the difference between `CHAR` and `VARCHAR` in MySQL?
21. What are the different data types available in MySQL?
22. What is a `Transaction` in MySQL?
23. Explain the `ACID` properties in MySQL.
24. How do you backup and restore a MySQL database?