ASP. NET developers use various available technologies for State Management. We can classify them as client side state management or server side state management. Asp Net Session State Serialization' title='Asp Net Session State Serialization' />Interview Questions in ASP. NET,C. NET,SQL Server. NET Framework. ASP. NET,C. NET,VB. NET,JQuery,Java. Script,Gridview. Here I am posting the interview questions whatever i have faced in my interviews I have searched for so many websites and gathered information from my friends to answer the questions perfectly. NET The most common question for experience persons is. Why would you like to change the companyI am looking for a more challenging career in a firm with a larger employee base such as yours. Keeping in mind my career goals, the time has come for me to move onto the next rung of the ladder and make a mark for myself. This can be achieved in a company like this. It is just a career move to enhance my knowledge in my own area of interest. After completion of this question only interview will go for further questions. Difference between stored procedure and function. Procedure can return zero or n values whereas function can return one value which is mandatory. Procedures can have input, output parameters for it whereas functions can have only input parameters. This article explains in detail the Session State Management technique and its modes in ASP. Net. Procedure allows select as well as DML statement in it whereas function allows only select statement in it. Functions can be called from procedure whereas procedures cannot be called from function. Exception can be handled by try catch block in a procedure whereas try catch block cannot be used in a function. We can go for transaction management in procedure whereas we cant go in function. Procedures cannot be utilized in a select statement whereas function can be embedded in a select statement. Difference between Abstract and Interface. Brij Mishra looks at web app state management, and Microsofts InMemory OLTP, to provide ASP. NET with a faster Session State Provider. Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers. I always use a wrapper class around the ASP. NET session to simplify access to session variables public class MySession private constructor private MySession. ASP. NET interview questions and answers for freshersbeginners and experienced. Our advanced ASP. Net interview questions are very useful for experienced ASP. NET. Abstract Class. Abstract class provides a set of rules to implement next class Rules will be provided through abstract methods Abstract method does not contain any definition While inheriting abstract class all abstract methods must be override If a class contains at least one abstract method then it must be declared as an Abstract Class Abstract classes cannot be instantiated, but a reference cannot be created Reference depends on child class objects memory Abstract classes are also called as Partial abstract classes Partial abstract class may contain functions with body and functions without body If a class contains all functions without body then it is called as Fully Abstract Class InterfaceInterface. Bejeweled 3 Free Download For Android Tablet on this page. If a class contains all abstract methods then that class is known as Interface Interfaces support like multiple inheritance In interface all methods r public abstract by default Interfaces r implementable Interfaces cannot be instantiated, but a reference can be created. Index types in SQL Server. Clustered Index. Only 1 allowed per table physically rearranges the data in the table to confirm to the index constraints for use on columns that are frequently searched for ranges of data for use on columns with low selectivity. Non Clustered Index. Up to 2. 49 allowed per table creates a separate list of key values with pointers to the location of the data in the data pages For use on columns that are searched for single values A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. Cara Install Windows 7 Notebook Acer. The leaf nodes of a clustered index contain the data pages. A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. Included Column Index New in SQL Server 2. In SQL Server 2. 00. Non key columns can help to create cover indexes. By including non key columns, you can create non clustered indexes that cover more queries. The Database Engine does not consider non key columns when calculating the number of index key columns or index key size. Non key columns can be included in non clustered index to avoid exceeding the current index size limitations of a maximum of 1. Another advantage is that using non key column in index we can have index data types not allowed as index key columns generally. In following example column Filename is varchar4. If we still want to include in our cover index to gain performance we can do it by using the Keyword INCLUDE. USE Adventure. Works. GOCREATE INDEX IXDocumentTitle. ON Production. Document Title, RevisionINCLUDE File. NameNon key columns can be included only in non clustered indexes. Columns cant be defined in both the key column and they INCLUDE list. Column names cant be repeated in the INCLUDE list. Non key columns can be dropped from a table only after the non key index is dropped first. For Included Column Index to exist there must be at least one key column defined with a maximum of 1. Avoid adding unnecessary columns. Adding too many index columns, key or non key as they will affect negatively on performance. Fewer index rows will fit on a page. This could create IO increases and reduced cache efficiency. More disk space will be required to store the index. Index maintenance may increase the time that it takes to perform modifications, inserts, updates, or deletes, to the underlying table or indexed view. Another example to test Create following Index on Database Adventure. Works in SQL SERVER 2. USE Adventure. Works. GOCREATE NONCLUSTERED INDEX IXAddressPostal. Code. ON Person. Address Postal. CodeINCLUDE Address. Line. 1, Address. Line. 2, City, State. Province. IDGOTest the performance of following query before and after creating Index. Fast And Furious 7 Hd Dvdrip Download there. The performance improvement is significant. SELECT Address. Line. Address. Line. 2, City, State. Province. ID, Postal. Code. FROM Person. Address. WHERE Postal. Code BETWEEN 9. 80. AND 9. 99. 99 GOInterview questions What are differences between Array list and Hash table Ans 1 Hash table store data as name, value pair. While in array only value is store. To access value from hash table, you need to pass name. While in array, to access value, you need to pass index number. What are differences between system. The main difference is system. Append keyword is used in string builder but not in system. Immutable means once we created we cannot modified. Suppose if we want give new value to old value simply it will discarded the old value and it will create new instance in memory to hold the new value. What are the differences between Application object and session objectAns The session object is used to maintain the session of each user. If one user enter in to the application then they get session id if he leaves from the application then the session id is deleted. If they again enter in to the application they get different session id. But for application object the id is maintained for whole application. What are the different types of indexes Ans Two types of indexes are there one is clustered index and non clustered index. How many types of memories are there in. Ans Two types of memories are there in. Is it possible to set the session out time manually Ans Yes we can set the session out time manually in web. What are differences between function and stored procedure Ans 1 Function returns only one value but procedure returns one or more than one value. Function can be utilized in select statements but that is not possible in procedure. Procedure can have an input and output parameters but function has only input parameters only.