1. What are the various types of joins?
2. What are the differences between Having and Where?
3. What are the difference between Delete and Drop?
4. What are the difference between Delete and Truncate?
5. What are the various types of triggers?
6. What are the differences between SP and Functions?
7. What is the difference primary key and foreign key?
8. How many clustered indexes you can create on a table?
9. Is it possible to RollBack without transactions?
10. What is a delegate?
