MySQL Interview Cheat Sheet

1. What is MySQL?

Entry Full Answer →

2. What is a database table?

Entry Full Answer →

3. What is a primary key?

Entry Full Answer →

4. What is a foreign key?

Entry Full Answer →

5. What is SQL?

Entry Full Answer →

6. What are the different types of SQL commands?

Entry Full Answer →

7. What is a constraint in MySQL?

Entry Full Answer →

8. What is the difference between CHAR and VARCHAR?

Entry Full Answer →

9. What is the purpose of the SELECT statement?

Entry Full Answer →

10. What is a WHERE clause used for?

Entry Full Answer →

11. What is ORDER BY used for?

Entry Full Answer →

12. What is LIMIT in MySQL?

Entry Full Answer →

13. What is a JOIN?

Entry Full Answer →

14. What is an index in MySQL?

Entry Full Answer →

15. What is NULL in MySQL?

Entry Full Answer →

16. Difference between DELETE and TRUNCATE?

Entry Full Answer →

17. What does AUTO_INCREMENT do?

Entry Full Answer →

18. What is a default value in MySQL?

Entry Full Answer →

19. What is the purpose of GROUP BY?

Entry Full Answer →

20. What is an aggregate function?

Entry Full Answer →

21. How does MySQL’s InnoDB storage engine manage transactions internally?

Junior Full Answer →

22. What is MVCC (Multi-Version Concurrency Control) in MySQL?

Junior Full Answer →

23. What is the purpose of the InnoDB buffer pool?

Junior Full Answer →

24. What is a covering index?

Junior Full Answer →

25. What is an execution plan and why is EXPLAIN important?

Junior Full Answer →

26. What is the difference between row-level and table-level locking?

Junior Full Answer →

27. How does MySQL handle indexing on large tables?

Junior Full Answer →

28. What is a slow query log and when should you enable it?

Junior Full Answer →

29. What is the difference between logical and physical backups?

Junior Full Answer →

30. What is a stored routine and why use it?

Junior Full Answer →

31. How does MySQL handle foreign key constraints during deletes or updates?

Junior Full Answer →

32. What is partitioning and when is it useful?

Junior Full Answer →

33. What are FULLTEXT indexes and when are they used?

Junior Full Answer →

34. What is a deadlock detector in InnoDB?

Junior Full Answer →

35. How do prepared statements improve performance and security?

Junior Full Answer →

36. What are triggers and their performance implications?

Junior Full Answer →

37. What is the difference between CHAR, VARCHAR, and TEXT in performance?

Junior Full Answer →

38. How do you optimize JOIN performance in MySQL?

Junior Full Answer →

39. How does MySQL handle replication?

Junior Full Answer →

40. What are common reasons for slow MySQL performance?

Junior Full Answer →

41. What is the difference between INNER JOIN and LEFT JOIN?

Mid Full Answer →

42. What is a composite primary key?

Mid Full Answer →

43. What is the use of the DISTINCT keyword?

Mid Full Answer →

44. What is an alias in MySQL?

Mid Full Answer →

45. What is the purpose of HAVING clause?

Mid Full Answer →

46. What is the difference between UNION and UNION ALL?

Mid Full Answer →

47. What is a subquery?

Mid Full Answer →

48. What is a self join?

Mid Full Answer →

49. What are MySQL data types?

Mid Full Answer →

50. What is a view?

Mid Full Answer →