SQL Server Frequently asked questions for .Net Programmers

1.  What is normalization In SQL Server? 
2.  What is an index and types of indexes? How many numbers of indexes can be used per table in SQL Server?
3.  What is a constraint? How many Types of constraints are there in SQL Server?
4. What are code pages in SQL Server?
5. What is referential integrity in SQL Server?
6. What is a trigger? How many types of triggers are there in SQL Servr?
7. What are different types of joins in SQL Server?
8. What is a self join and Give an Example in SQL Server?
9. Explain Authentication mechanisms in Sql Server?
10. What are the user defined stored procedures?
11. What is INSTEAD OF trigger in SQL Server?
12. How to optimize a query that retrieves data by joining 4 tables?
13. What is the Usage of DTS in SQL Server?
14. How to disable an index using select query in SQL Server?
15. Is non-clustered index faster than clustered index? Why?
16. Explain different types of optimization in queries?
17. What is the difference between ISQL and OSQL in SQL Server?
18. How you log an exception directly into Sql server what is used for this?
19. Explain about Replication in Database?
20. What is the default optimization done in oracle and Sql server?
21. How can I make a column as unique in SQL Server?
22. How many no of tables can be joined in same SQL Server?
23. How many columns can exist per table in SQL Server?
24. Explain about Sql Profiler usage in SQL Server?