.Net Database Interview Questions

 
1.
What is State?
2.
What is differences between framework 1.0 and framework 1.1?
3.
Explain What are the types of cookies are there?
4.
Explain What is Task?
5.
Explain What is indexing?
6.
Explain atleast three methods of response object other than Redirect?
7.
How to deploy an asp.net application?
8.
Explain What is the maximum length of a varchar in SQL Server?
9.
Explain an execution plan? When would you use it? How would you view the execution plan?
10.
Explain atleast two methods of response object other than Transfer?
11.
Explain How many objects are there in ASP?
12.
Explain What are cursors? Name four type of cursors and when each one would be applied?
13.
Explain What is the STUFF function and how does it differ from the REPLACE function?
14.
Explain the use of trace utility?
15.
What is differences between Server.Transfer and server.execute method?
16.
What is differences between ADO and DAO?
17.
Explain What is referential integrity and how can we achieve it?
18.
Explain the different types of replication? How are they used?
19.
Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?
20.
Explain similarities and differences between the Java and .NET?
21.
Explain What is the .NET datatype that allows the retrieval of data by a unique key?
22.
Explain What are good ADO.NET object(s) to replace the ADO Recordset object?
23.
Explain How do we separate business logic while creating an ASP.NET application?
24.
What is State?
25.
What is differences between framework 1.0 and framework 1.1?
26.
Explain What are the types of cookies are there?
27.
Explain What is Task?
28.
Explain What is indexing?
29.
Explain atleast three methods of response object other than Redirect?
30.
How to deploy an asp.net application?
31.
Explain What is the maximum length of a varchar in SQL Server?
32.
Explain an execution plan? When would you use it? How would you view the execution plan?
33.
Explain atleast two methods of response object other than Transfer?
34.
Explain How many objects are there in ASP?
35.
Explain What are cursors? Name four type of cursors and when each one would be applied?
36.
Explain What is the STUFF function and how does it differ from the REPLACE function?
37.
Explain the use of trace utility?
38.
What is differences between Server.Transfer and server.execute method?
39.
What is differences between ADO and DAO?
40.
Explain What is referential integrity and how can we achieve it?
41.
Explain the different types of replication? How are they used?
42.
Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?
43.
Explain similarities and differences between the Java and .NET?
44.
Explain What is the .NET datatype that allows the retrieval of data by a unique key?
45.
Explain What are good ADO.NET object(s) to replace the ADO Recordset object?
46.
Explain How do we separate business logic while creating an ASP.NET application?
47.
Define .Net Assembly?
48.
What does the dot net assembly contain?
49.
Define private assembly and a shared dot net assembly?
50.
What are Satellite Assemblies?
51.
What do you understand by side-by-site execution of assembly?
52.
How do you create a resource-only assembly?
53.
Explain how to retrieve resources using ResourceManager class?
54.
Define Strong Name. How do you apply a strong name to assembly?
55.
Define Global Assembly Cache in dot net?
56.
How do you install assembly to the Global Assembly Cache?