Dotnet Interview Questions

1. What is an interface?
2. What do you know about web service?
3. What is a nullable type?
4. Difference between value type and reference type?
5. Difference between hash table and array list?
6. What is a web service?
7. Diff between string and string builder?
8. Diff between user control and custom control. And how to use them?

Regarding the project:

1) Project explanation

2) What I have done in the project?

3) How asked about the database tables and how they are used in the .NET code

4) Currently what I am doing? For this I said there are some performance issues in the project so we are planning to redesign the project.

Then he asked how we are solving the issues?

SQL Server:

1. What is a trigger?
2. What are various types of joins?
3. What are DML and DDL commands?
4. Employee table:


EmpId EmpName Place City Country


If country is having null values write a query which replaces null values with India?

Ans : Select Empid, empname ,place,city ,isnull(Country,’india’) from Employee

5. Different types of joins

6. Write a query for Self Join?

===================================================================

1. What are the interested areas that u worked in ur current project
2. Explain ASP.Net page LifeCycle.
3. What are the New features .net 3.5 ?
4. What is an interface
5. What are the Oops Concepts that are used in ur project..
6. What is abstract classes in which scenario u choose abstract clases over an interface.. ?
7. What is the use Static classes.. ?
8. How do u implement Encapusaltion in dotnet.. ?
9. Difference between gridview and datagrid.. /
10. If you enable the EnableViewState and disable all the controls What it happens.
11. How can we install dll explicitly in .Net.
12. Solve this
Int a=5;
String str ;
Str = a; // We have to convert the int into string.
Will the program gets executed or else whats the error u rgetting how can u clear it.

1. Does Object is Value type or reference type.
2. What is stack and Queue.Examples of these.

13. Use of garbage collector ?
14. CTS .. ?
15. Can we use insert statement into the cursor or we had only direct insert statement.
16. What is meant by View state
17. Is it possible to view the data in view state..
18. Diiference between Storedprocedure and function .. ?
19. Can we write.. an update statement in function ?

===================================================================

Difference between User controls and Custom Controls
Differnece between Dataset.Acceptchanges() and DataAdapter.Update methods
Difference between Having and Where clause
Difference between Trace and Asset
Difference between constant and static variables
Difference between XML and xmlRPC
what is zagged Array in c#
COLLATE
multicast delegate
WSDL
UDDI
what is webmethod
which protocol will be used in web services
what is this operator
how you will see the Trace in the output window
what is master database

=================================================================

Difference between functions and Stored procedure
what is trigger
difference between stored procedure and trigger
why do we need trigger
what is stored procedure ? how it will reduce the network traffic
Is data will be stored by using Stored Procedure
what is virtual
class A having Add method and class B Add method defined
if class B inherits class A then how you will access Add method from class A
what is LINQ ? what it will do ? why do we need ?
how LINQ and database will be related
Is LINQ is best or stored procedure
explain present project
why do we needs Views

=====================================================================