MySQL interview questions for experienced candidates
IT & Software
Database Management
1. What is MySQL clustering?
2. How do you create a database in MySQL?
3. What are the differences between SQL and MySQL?
4. What is normalization in MySQL?
5. What are the different data types in MySQL?
Querying Data
1. How do you retrieve data from a table in MySQL?
2. What is the purpose of the SELECT statement in MySQL?
3. How do you filter data in MySQL?
4. How do you sort and limit data in MySQL?
5. How do you join tables in MySQL?
Database Design
1. What is the difference between CHAR and VARCHAR data types?
2. How do you create an index in MySQL?
3. What is the difference between a clustered index and a non-clustered index?
4. How do you handle the –secure-file-priv in MySQL?
5. What are the different types of relationships in MySQL?
Advanced Topics
1. What is InnoDB?
2. What is a heap table in MySQL?
3. What is the difference between DELETE and TRUNCATE commands in MySQL?
4. How do you control the max size of a heap in MySQL?
5. What are triggers in MySQL
