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