3rd Interview(TCS)

1. What is view_State?
A. The View_State is a client side state management. which maintain or stores the information of page controles with unique ID in encrypted formate.When the page is processed, the current state of the page and controls is hashed into a string and saved in the page as a hidden field, or multiple hidden fields

2.Write The query for fallowing table salary field null values filled with 10000, with out using Update?
Emp_ID Salary
A 5000
B Null
C 3000
D Null
E Null
A.

3.What is serialization?
A.Serialization is a process of converting an object into a stream of data so that it can be is easily transmittable over the network or can be continued in a persistent storage location. This storage location can be a physical file, database or ASP.NET Cache.
Serialization can be defined as the process of storing the state of an object instance to a storage medium. During this process, the public and private fields of the object and the name of the class, including the assembly containing the class, is converted to a stream of bytes, which is then written to a data stream. When the object is subsequently deserialized, an exact clone of the original object is created.

4. what advantages of stored procedures?
A. 1.Execution plan retention and reuse
2.Query auto-parameterization
3.Encapsulation of business rules and policies
4.Application modularization
5.Sharing of application logic between applications
6.Access to database objects that is both secure and uniform
7.Consistent, safe data modification
8.Network bandwidth conservation
9.Support for automatic execution at system start-up
10.Enhanced hardware and software capabilities
11.Improved security
12.Reduced development cost and increased reliability
13.Centralized security, administration, and maintenance for common routines

5.What type of Execeptions used in ur application?
A.An exception is an error condition or unexpected behavior encountered by an executing program during runtime.
System.OutOfMemoryException
System.NullReferenceException
Syste.InvalidCastException
Syste.ArrayTypeMismatchException
System.IndexOutOfRangeException
System.ArithmeticException
System.DevideByZeroException
System.OverFlowException
Sql Exception.

6. Where you will set your connection string?How to Access through your page?
A. IN Web.config File, we can access this conn through configuration manager.

7.What is ajax?
A.Ajax (shorthand for asynchronous JavaScript and XML[1]) is a group of interrelated web development techniques used on the client-side to create interactive web applications. With Ajax, web applications can retrieve data from the server asynchronously in the background without interfering with the display and behavior of the existing page.

7.What is a view?
A A view is a virtual table contails columns of one or more tables. a view contains logical information of physical tables.

8.WHAT IS TRIGGER?
A. Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected.

DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established. Triggers can be created directly from Transact-SQL statements or from methods of assemblies that are created in the Microsoft .NET Framework common language runtime (CLR) and uploaded to an instance of SQL Server. SQL Server allows for creating multiple triggers for any specific statement.
Trigger

9.What is indexing?How many indexes we can create on a table?if we have more indexes it will degrade the performance of a table?
A.An index is a database object created and maintained by DBMS.An index is an on-disk structure associated with a table or views that speed retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view”. These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.”
SQL Server has two major types of indexes:

1.Clustered
2.Non-Clustered
A table can have only one clustered index
and 249 non clustered index.
The performance: If a table has too many indexes associated with it, the updates or inserts or deletes on it would slow down.

10.What is paging in gridview?How to set first 20 records in grid view?What are the properties of gridview>
A. Paging is the property of gridview, which allows you to navigate the next records.
See link Grid view Properties
In page size property of grid view we will set

11.How to set the check Box control in Gridview?
A.

12. What is cookies?
A.Most browsers support cookies of up to 4096 bytes.
A Cookie is a small text file that the browser creates and stores on the hard drive of your machine. Cookie is just one or more pieces of information stored as text strings. A Web server sends you a cookie and the browser stores it. The browser then returns the cookie to the server the next time the page is referenced.
Creating cookies with ASP.NET is simple and straight forward. The System.Web namespace offers a class called HttpCookie to create cookies