Scribd
Upload
4 views3 pages

MySQL Interview Questions

This document contains a comprehensive list of MySQL interview questions categorized into sections such as Database Fundamentals, Tables, Keys, and Constraints, SQL Commands, Querying Data, Functions and Grouping, and Joins and Relationships. Each section addresses key concepts and differences related to MySQL, including definitions, commands, and data types. It serves as a study guide for individuals preparing for MySQL-related interviews.

Uploaded by

himanshuparadeshi21
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

MySQL Interview Questions

This document contains a comprehensive list of MySQL interview questions categorized into sections such as Database Fundamentals, Tables, Keys, and Constraints, SQL Commands, Querying Data, Functions and Grouping, and Joins and Relationships. Each section addresses key concepts and differences related to MySQL, including definitions, commands, and data types. It serves as a study guide for individuals preparing for MySQL-related interviews.

Uploaded by

himanshuparadeshi21
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MySQL Interview Ques ons

Database Fundamentals
1. What is MySQL?
2. What is a database?
3. What is DBMS?
4. What is RDBMS?
5. Difference between DBMS and RDBMS?
6. What are the features of MySQL?
7. What are the advantages of MySQL?

8. What are MySQL data types?


9. Difference between CHAR and VARCHAR?
10. Difference between INT, FLOAT, and DECIMAL?

Tables, Keys, and Constraints


11. What is a table in MySQL?
12. What is a row (record)?
13. What is a column (field)?
14. What is a Primary Key?
15. What is a Foreign Key?
16. What are constraints in MySQL?
17. What is NOT NULL constraint?
18. What is UNIQUE constraint?
19. What is DEFAULT constraint?
20. What is AUTO_INCREMENT?

SQL Commands
21. What is SQL?
22. What are DDL commands?
23. What are DML commands?
24. What are DQL commands?
25. What are DCL commands?

26. What are TCL commands?


27. Difference between DELETE, DROP, and TRUNCATE?
28. Difference between COMMIT and ROLLBACK?

Querying Data
29. What is SELECT statement?
30. What is WHERE clause?
31. What is ORDER BY clause?
32. Difference between ASC and DESC?
33. What is LIMIT clause?
34. What is DISTINCT?
35. What is the LIKE operator?
36. Difference between % and _ wildcards?
37. What is IN operator?
38. What is BETWEEN operator?
39. What is NULL?
40. Difference between NULL and NOT NULL?

Func ons and Grouping


41. What are aggregate func ons?
42. Explain COUNT() func on.
43. Explain SUM() func on.
44. Explain AVG() func on.
45. Explain MIN() and MAX() func ons.
46. What is GROUP BY clause?
47. What is HAVING clause?
48. Difference between WHERE and HAVING?
Joins and Rela onships

49. What is a JOIN?


50. Difference between INNER JOIN and OUTER JOIN?

You might also like