Interview Question for Experienced

1)      What is Table Datatype in SQL?

2)      Create proc ABC

              {

Select * from Customer;

Select * from Order;                  

}

How to get both table on .cs page?

 3) Difference between Querystring And POST ?

 4) What is TEMP table in SQL & Types & Scope ?

 5)What is HttpWebRequest ?

 6)What is View ?

 7) Where Session data Store?

8) Viewstate (Client Side or Server Side)?

  Answer-

            There are two different types of state management:

1. Client Side State Management
• View State
• Hidden Field
• Cookies
• Control State
2. Server Side State Management
• Session
• Application Object
• Caching
• Database

9)A gridview have 1000000 records. What you will do so that grid load faster?

Answer-we will leverage custom paging, caching and AJAX. We will also implement sorting to load    gridview fast.

10) Page life cycle stage ?

11) Can a class uses as a service Contract ?

12) what is fault Contract?

13)what is message contract?

14)Difference between class and interface? 

15) Difference between  abstract class and interface ?

16)what is index and there types?

17)can wcf interface have overloaded function? If yes then how can access at client side?

18)Types of joining.  And example of self join?

19)Difference between Stored Procedure and function?

20) Write code for URL rewriting code in web.config?

  Answer—

<urlMappings enabled="true">

    <add url="~/index.htm" mappedUrl="~/default.aspx"/>

 <add url="~/mypage" mappedUrl="~/mypage.aspx"/>

</urlMappings>

21)How to remove special characters from XML write code?

22) Xml case sensitive or not?

Answer-  Xml is Case Sensitive .

23) Difference between read only & constant & static variable ?

Answer-

            readonly is a runtime constant while const is a compile time constant i.e. you can intialize the value of variable only once at runtime in a constructor and if you try to modify later it will throw error while const is once declared during compilation can't be changed at runtime
another important thing about const is that const can be applied with value types only because you simply can't intialize the reference type at compilation. so to make a constant ref type you need to use Readonly
while static is altogether different from these two. static variable is a property of a class rather than the insatnce of class i.e. static represnt a kind of a global value for all the instances of that class

24)what is static variable ?

Answer-

            The static keyword can be used to declare variables, functions, class data members and class functions.
By default, an object or variable that is defined outside all blocks has static duration and external linkage. Static duration means that the object or variable is allocated when the program starts and is deallocated when the program ends. External linkage means that the name of the variable is visible from outside the file in which the variable is declared. Conversely, internal linkage means that the name is not visible outside the file in which the variable is declared.
The static keyword can be used in the following situations.

·         When you declare a variable or function at file scope (global and/or namespace scope), the static keyword specifies that the variable or function has internal linkage. When you declare a variable, the variable has static duration and the compiler initializes it to 0 unless you specify another value.

·         When you declare a variable in a function, the static keyword specifies that the variable retains its state between calls to that function.

·         When you declare a data member in a class declaration, the static keyword specifies that one copy of the member is shared by all instances of the class. A static data member must be defined at file scope. An integral data member that you declare as const static can have an initializer.

·         When you declare a member function in a class declaration, the static keyword specifies that the function is shared by all instances of the class. A static member function cannot access an instance member because the function does not have an implicit this pointer. To access an instance member, declare the function with a parameter that is an instance pointer or reference.

·         You cannot declare the members of a union as static. However, a globally declared anonymous union must be explicitly declared static.

25)why make a class as static ?

26)what is OUT keyword?

27)why declare a function as virtual ?

28)How many events you use of Page Life Cycle?

29)How many ways can take WCF reference at client side ?

30)What is end point in WCF ?

31) How many types of Binding in WCF?

32) Difference between basicHttpBinding and wsHttpBinding ?

33)Write a query for  Find top 2 record from table ?

34) what is  IFNULL in sql?

35)Difference between SQL Server 2005 & 2008?

Answer—

Sr No	SQL Server 2005	SQL Server 2008
1	XML datatype is introduced.	XML datatype is used.
2	Can not encrypt the entire database.	Can encrypt the entire database introduced in 2008.
3	Datetime is used for both date and time.	Date and time are seperately used for date and time
4	No table datatype is included.	Table datatype introduced.
5	SSIS is started using.	SSIS avails in this version.
6	CMS is not available.	Central Management Server(CMS) is Introduced.
7	PBM is not available	Policy based management(PBM) server is Introduced.

36) What is Application Pool ?

37)Difference between Application Pool  & Application Domain ?

38) What is Connection Pool ?

39) Difference between Web Form & Web Gardening ?