Dotnet Database interview Questions

1. Dotnet Database interview Questions
   
2. What is the use of trace utility?
3. What does Server.Map Path do?
4. How do you create thread in .NET?
5. How many objects are there in ASP?
6. How to deploy an asp.net application?
7. What are the types of cookies are there?
8. How can you deploy an asp.net application?
9. Explain how many objects are there in ASP?
10. What is differences between ADO and DAO?
11. How do we upgrade SQL Server 7.0 to 2000?
12. Explain what are the types of cookies are there?
13. Which DLL file is needed to be registered for ASP?
14. What is the purpose of using COLLATE in a query?
15. What are the advantages/disadvantages of view state?
16. How do u call and execute a stored procedure in .NET?
17. What is referential integrity and how can we achieve it?
18. What is de-normalization? When do you do it and how?
19. What is the maximum length of a varchar in SQL Server?
20. Explain similarities and differences between Java and .NET?
21. Explain the different types of replication? How are they used?
22. What are the different types of replication? How are they used?
23. Explain differences between framework 1.0 and framework 1.1?
24. Explain what is the maximum length of a varchar in SQL Server?
25. Explain at least two methods of response object other than Transfer?
26. Explain at least three methods of response object other than Redirect?
27. How do SQL Server 2000 and XML linked? What is SQL Server agent?
28. What are good ADO.NET object(s) to replace the ADO Record set object?
29. Explain differences between Servers. Transfer and server. Execute method?
30. How do you separate business logic while creating an ASP.NET application?
31. What is the .NET data type that allows the retrieval of data by a unique key?
32. What is the STUFF function and how does it differ from the REPLACE function?
33. Explain what are good ADO.NET object(s) to replace the ADO Record set object?
34. Describe session handling in web form. How does it work and what are the limits?
35. Explain how do we separate business logic while creating an ASP.NET application?
36. Explain what is the .NET data type that allows the retrieval of data by a unique key?
37. What are cursors? Name four type of cursors and when each one would be applied?
38. What are the differences between User control and Web control and Custom control?
39. Explain what is the STUFF function and how does it differ from the REPLACE function?
40. Explain what are cursors? Name four type of cursors and when each one would be applied?
41. How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
42. What is an execution plan? When would you use it? How would you view the execution plan?
43. How does you handle this COM components developed in other programming languages in .NET?
44. Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?
45. How do you find the error, how can you know the number of rows affected by last SQL Statement?
46. What is the difference between a Local temporary table and a Global temporary table? How is each one used?