| S.No | Question |
|---|---|
| 1. | What is SQL? |
| 2. | What are different types of statements supported by SQL? |
| 3. | What is DBMS? |
| 4. | What is RDBMS? |
| 5. | Why do we use SQL Constraints? Which constraints we can use while creating database in SQL? |
| 6. | What are different JOINS used in SQL? |
| 7. | What is Normalization? |
| 8. | What are all the different Normalization? |
| 9. | How many Aggregate Functions are available there in SQL? |
| 10. | What is SQL Injection? |
| 11. | What is the difference between "Primary Key" and "Unique Key"? |
| 12. | What is isNULL() operator? |
| 13. | How to change Database name in SQL server? |
| 14. | How to implement one-to-one, one-to-many and many-to-many relationships while designing tables? |
| 15. | What is CHECK Constraints? |
| 16. | What is an SQL View? |
| 17. | What is a Composite Primary Key? |
| 18. | What are user defined datatypes and when you should go for them? |
| 19. | What is the SELECT statement? |
| 20. | What is an Alias in SQL? |
| 21. | What is Denormalization? |
| 22. | What is the difference between DROP and TRUNCATE statements? |
| 23. | What is the difference between DELETE and TRUNCATE statements? |
| 24. | How can you fetch first 5 charcter of the string? |
| 25. | What is a Primary Key? |
| 26. | What is a Unique Key? |
| 27. | What is a foreign key? |
| 28. | What do you understand by Self Join? |
| 29. | What is the differnce between Union and Union All operators? |
Office no.- 401,Shekhar Central Building ,Palasiya, Pin-code:452001, Indore
contact@codebetter.in
+91 88230 75444, +91 99939 28766