2. What are the differences between Stored Procedure and Stored Function?
3. What are the advantages of using Stored Procedure?
4. How to get the count of records in a database table?
5. What is the difference between a Primary Key and a Unique Key in SQL Server?
6. Differences between Delete and Truncate in SQL Server.
7. What is the difference between a UNION and a JOIN?
8. What is ORDER BY and how is it different than clustered index?
9. What is a Join? Explain Different Types of Joins.
10. What is Trigger and explain the types of triggers in SQL?
11. What is RDBMS?
12. What are the properties of the Relational tables?
13. What is Normalization?
14. What are the different normalization forms?
15. What is De-normalization?
16. What is View?
17. What is Index?
18. What is the Linked Server?
19. What is the Cursor?
20. What is Collection?
21. What is Sub-query? Explain the properties of sub-query.
22. What are the Primary Key and Foreign Key?
23. What are User Defined Functions? What kind of User-Defined Functions can be created?
24. What is Identity?
25. What is Data Warehousing?
26. What is TCP/IP port does SQL run on? How can it be changed?
27. What are the different index configurations a table can have?
28. What is Collation Sensitivity and what are the different types of Collation Sensitivity?
29. What is OLTP (Online Transaction Processing)?
