SQL_Notes_-_Interview_Questions

Starting SQL Interviews Preparation .

Start your SQL interview preparation journey with a Complete list of Interview Questions. Stay one step forward with preparing these interview Questions.

1. What is a database, and how is it different from a DBMS?
2. How does MySQL differ from other relational database management systems?
3. What are the main data types available in MySQL?
4. What is the difference between INT and DECIMAL data types?
5. How is DATE different from DATETIME in MySQL?
6. What is a foreign key, and how would you use it in databases?
7. What are the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
8. What is the difference between DELETE, TRUNCATE, & DROP in MySQL?
9. How do you create and modify a table in MySQL? Provide examples.
10. What is a temporary table in SQL?
11. What is a subquery in MySQL? Explain with an example.
12. How would you use an INSERT statement in MySQL to add data to a table? Also, do you have some best practices for this?
13. What is the significance of the AUTO_INCREMENT attribute in MySQL?
14. What is a view in MySQL?

=> 𝗜𝗻𝘁𝗲𝗿𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝗟𝗲𝘃𝗲𝗹 15. What are system-versioned tables, and how do they work? 16. What are MySQL transactions, and how do you use them? 17. What is a default constraint in MySQL? How do you set a default value for a column? 18. How would you use string functions in SQL to manage text? 19. How would you update a specific row in a database with SQL?

=> 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 20. What is a trigger in MySQL? How do you implement it? 21. Why does adding an index make SQL queries faster? 22. What data type do we use for the product's weight and price in an SQL table, and why? 23. How do you find duplicate rows in SQL with a window function? 24. How do you create and use a stored procedure with parameters in MySQL? Explain with an example. 25. Why is referential integrity important in a database?

=> 𝗙𝗼𝗿 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗔𝗱𝗺𝗶𝗻𝗶𝘀𝘁𝗿𝗮𝘁𝗼𝗿𝘀 26. Why would a large application use database Sharding? Also, tell me about the challenges with it. 27. Explain the role of redo logs in MySQL crash recovery. 28. What are the different storage engines available in MySQL, and how do they differ? 29. How would you set a default storage engine in MySQL? 30. How would you repair corrupted tables in MySQL?

=> 𝗦𝗰𝗲𝗻𝗮𝗿𝗶𝗼-𝗕𝗮𝘀𝗲𝗱 𝗮𝗻𝗱 𝗣𝗿𝗼𝗯𝗹𝗲𝗺-𝗦𝗼𝗹𝘃𝗶𝗻𝗴 31. Explain a scenario where you used subqueries in MySQL. 32. Can you explain a situation where you used SQL joins to combine data from multiple tables? 33. Do you have any experience with triggers? Explain how you’ve used them. 34. Write a query to find the manager for each employee in a company, even if the employee doesn't have a manager assigned.