Interview Questions ASP.NET VIEW STATE

1). What is View State in Asp.net? Ans: View state is nothing but a method that the ASP.NET use to preserve page and control values between postbacks. When the HTML markup for the page is rendered, the current state of the page and values that must be retained during postback are serialized into base64-encoded strings. This information is then put into the view state hidden field. 2). View state is client-side or server side state management techenique? Ans: View state is client-side...

Read More »

Interview Questions ASP.NET State Management Techniques

Here are the top 10 questions answers for both experienced and beginners asp.net developers. 1).What is state management? Ans: State management is the process by which you maintain state and page information over multiple requests for the same or different pages. 2).Http is stateless, What does this mean? Ans: Stateless protocol is a communications protocol that treats each request as an independent transaction that is unrelated to any previous request so that the communication consists...

Read More »

SQL Server interview questions | triggers all about triggers

Explain Triggers? A trigger is a special type of event driven stored procedure.  It gets initiated when Insert, Delete or Update event occurs.  It can be used to maintain referential integrity.  A trigger can call stored procedure. Executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. You can specify which trigger fires first or fires last using sp_settriggerorder. Triggers can't be invoked on demand. They get triggered...

Read More »

SQL Server interview questions | data integrity constraints

SQL Server interview questions | data integrity constraints What is primary key? A Primary Key in a table identifies each and every row uniquely. It should not allow null values. We could assign primary key on only column or more than one column also. What is the difference between primary key and unique key? Primary should not allow null; where as unique key will allow nulls. By default Primary key is created as clustered...

Read More »

SQL Integrity Constraints Foreign Key Not Null Unique Check

SQL Integrity Constraints Integrity Constraints are used to apply business rules for the database tables. Enforcing data integrity ensures the quality of the data in the database.  For example, if an employee is entered with an employee_id value of 123, the database should not allow another employee to have an ID with the same value. Data integrity falls into these categories: Entity Integrity Entity integrity defines a row as a unique entity for a particular table....

Read More »

Exception Handling In SQL Server 2008 R2 (SQL Server Transactions and Error Handling)

Exception Handling In SQL Server 2008 R2 (SQL Server Transactions and Error Handling) Errors in Transact-SQL code can be processed by using a TRY…CATCH construct similar to the exception-handling features of the Microsoft Visual C++ and Microsoft Visual C# languages. A TRY…CATCH construct consists of two parts: a TRY block and a CATCH block. When an error condition is detected in a Transact-SQL...

Read More »