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

1. What is MySQL and what problems does it solve?

2. What are the major features of MySQL?

3. How does MySQL differ from other relational databases?

4. What are relational databases?

5. What are tables, rows, and columns in MySQL?

6. What are primary keys and foreign keys?

7. What are candidate keys and composite keys?

8. What are unique constraints?

9. What is normalization?

10. What are the different normal forms?