MySQL is an open-source relational database management system that uses SQL for data manipulation and is widely used in web applications and content management systems.

What is a primary key?

A primary key is a column or combination of columns that uniquely identifies each row in a table, ensuring data integrity and enabling efficient data retrieval.

SQL joins combine rows from two or more tables based on related columns. Common types include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

MySQL Interview Questions

11. What is denormalization?

12. When should denormalization be preferred?

13. What are relationships in relational databases?

14. How do one-to-one relationships work?

15. How do one-to-many relationships work?

16. How do many-to-many relationships work?

17. What are indexes in MySQL?

18. How do indexes improve query performance?

19. What are clustered and non-clustered indexes?

20. What are composite indexes?