1. To test a Web Service you must create a windows application or web application to consume this service? It is True/False?
2. How many classes can a single.NET DLL contain?
3. What are good ADO.NET object(s) to replace the ADO Recordset object?
4. On order to get assembly info which namespace we should import?
5. How do you declare a static variable and what is its lifetime? Give an example.
6. How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
7. How do you call and execute a Stored Procedure in.NET? Give an example.
8. What is the maximum length of a varchar in SQL Server?
9. How do you define an integer in SQL Server?
10. How do you separate business logic while creating an ASP.NET application?
11. If there is a calendar control to be included in each page of your application, and and we do not intend to use the Microsoft-provided calendar control, how do you develop it? Do you copy and paste the code into each and every page of your application?
12. How do you debug an ASP.NET application?
13. How do you deploy an ASP.NET application?
14. Explain similarities and differences between Java and.NET?
15. Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
16. What are theXML files that are important in developing an ASP.NET application?
17. What are theXML files that are important in developing an ASP.NET application?
18. What is XSLT and what is its use?
19. How many objects are there in ASP?
20. Which DLL file is needed to be registered for ASP?
21. Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating?
22. What does Server.MapPath do?
23. Name atleast three methods of response object other than Redirect.
24. Name atleast two methods of response object other than Transfer.
25. What is State?
26. Explain differences between ADO and DAO.
27. How many types of cookies are there?
28. Tell few steps for optimizing (for speed and resource) ASP page/application.
29. Which command using Query Analyzer will give you the version of SQL Server and Operating System?
30. Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
31. What is the purpose of using COLLATE in a query?
32. What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”?
33. What is an execution plan? When would you use it? How would you view the execution plan?
34. What is the STUFF function and how does it differ from the REPLACE function?
35. What does it mean to have quoted_identifier on? What are the implications of having it off?
36. What are the different type of replication? How are they used?
37. What is the difference between a Local temporary table and a Global temporary table? How is each one used?
38. What are cursors? Name four type of cursors and when each one would be applied?
39. What is the purpose of UPDATE STATISTICS?
40. How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
41. How do SQL Server 2000 andXML linked? What is SQL Server agent?
42. What is referential integrity and how can we achieve it?
43. What is indexing?
44. Explain differences between server.transfer and server.execute method?
45. What is de-normalization? When do you do it and how?
46. Explain features of SQL Server like Scalibility, Availability, Integration with Internet.
47. What is DataWarehousing?
48. What is OLAP?
49. How do we upgrade SQL Server 7.0 to 2000?
50. What is job?
51. What is Task?
52. How would you update the rows which are divisible by 10, given a set of numbers in column?
53. How do you find the error, how can you know the number of rows affected by last SQL Statement?
54. What are the advantages/disadvantages of viewstate?
55. Describe session handling in webform. How does it work and what are the limits?
56. Explain differences between framework 1.0 and framework 1.1
57. If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why and how? Give an example.
58. What is the use of trace utility?
59. What are the differences between User control and Web control and Custom control?
60. If I have more than one version of one assemblies, then how will I use old version in my application? Give an example.
61. How do you create threadinf in.NET?
62. Describe the Managed Execution Process.
63. What is Active Directory? What is the namespace used to access the Microsoft Active Directories?
64. What are Interop Services?
65. How does you handle this COM components developed in other programming languages in.NET?
66. How will you register COM+ services?