Dot Net integration with SQL Server Interview Questions and Answers

1.  What arc steps to load a .NET code in SQL SERVER 2005?
2.  How can we drop an assembly from SQL SERVER?
3.  Are changes made to assembly updated automatically in database?
4.  Why do we need to drop assembly for updating changes?
5.  How to see assemblies loaded in SQL Server?
6.  I want to see which files are linked with which assemblies?
7.  Does .NET CLR and SQL SERVER run in different process?
8.  Does .NET controls SQL SERVER or is it vice-versa?
9.  SQLCLR configured by default?
10. Is .NET feature loaded by default in SQL Server?
11. How does SQL Server control .NET run-time?
12. What's a "SAND BOX" in SQL Server 2005?
13. What is an application domain?
14. Does SQL Server handle unmanaged resources?
15. What is Multi-tasking?
16. What is Multi-threading?
17. What is a Thread ?
18. Can we have multiple threads in one App domain?
19. What is Non-preemptive threading?
20. What is pre-emptive threading?
21. Can you explain threading model in SQL Server?
22. How does .NET and SQL Server thread work?
23. How is exception in SQLCLR code handled?
24. Are all .NET libraries allowed in SQL Server?
25. What is "Hostprotectionattribute" in SQL Server 2005?
26. How do we define INPUT and OUTPUT parameters in SQLCLR?
27. Is it good to use .NET datatypes in SQLCLR?
28. What is System.Data.SqlServer?
29. What is SQLContext?
30. Which are the four static methods of SQLContext?

Posted in: SQL Server 2005 Interview Questions and Answers