SQL INTERVIEW QUESTIONS
1. What is data and information and explain differences between them?
2. What is database and explain various advantages of database?
3. What is database management system explain about advantages of DBMS?
4. Explain about various applications of database management system?
5. Define SQL and explain about advantages of SQL?
6. Explain the differences between SQL and DBMS?
7. Explain differences between SQL and NOSQL?
8. Explain the differences between DBMS, RDBMS and NON-RDBMS?
9. Explain about different types of Database management systems?
10. Explain briefly about SQL commands?
11. Explain about DDL commends and its advantages?
12. Explain about DML commends and its advantages?
13. Explain the differences between both DDL commands and DML commands?
14. Explain about TCL commends and its advantages?
15. Explain about differences between drop and truncate commands in SQL?
16. Explain about differences between delete and truncate commands in SQL?
17. Explain about differences between drop and delete commands in SQL?
18. Explain about use of alter command with examples?
19. Explain about both rollback and savepoint and explain differences between rollback and
savepoint?
20. Explain about the difference between char and varchar and nchar?
21. Explain about the differences between number and integer data type?
22. Explain about where clause, like clause and order by clauses with example queries?
23. Explain about various types of aggregate functions?
24. Briefly explain about group by clause with example?
25. Explain about having clause with example?
26. Differences between where and having clauses with examples?
27. What is a key in DBMS and explain various types of keys with examples?
28. Explain different types of constrains with examples?
29. Explain about primary key and foreign key with examples?
30. Differences between both primary key and foreign key with examples?
31. Explain about super key and candidate key and show the differences between super key and
candidate key?
32. Explain about both composite key and compound key?
33. Explain about alternate key and how it is differ from candidate key?
34. What is normalization and explain advantages of normalization?
35. What is database anomaly and explain different types of anomalies?
36. What is normal form and explain different types of normal forms?
37. What is functional dependency and explain different types of functional dependencies?
38. Explain about partial functional dependency and compare with fully functional
dependencies?
39. Explain about transitive, multivalued, join dependencies with examples?
40. Explain briefly about 1NF, 2NF, 3NF, BCNF, 4NF, 5NF with examples?
41. What is a transaction and explain about ACID properties in DBMS?
42. What is start transaction and explain about its advantages?
