what are the sealed classes in c# | uses of sealed keyword in c# |Sealed classes example in c# | Object-Oriented Programming: Sealed Classes

Introduction

Here I will explain what are the sealed classes in c# and uses of sealed classes in c#.

Description:

In previous article I explained clearly about OOPS concepts now I will explain what is the use of sealed classes in c#. Generally if we create classes we can inherit the properties of that created class in any class without having any restrictions. In some situation we will get requirement like we don’t want to give permission for the users to derive the classes from it or don’t allow users to inherit the properties from particular class in that situations what we can do? 

What is an application object and where we use application object in asp.net | application object sample using asp.net

Introduction:

In this article I will explain what application object is and I will explain how we will use application objects in asp.net.

Description:

Today I am writing this post to explain about application object in asp.net. In one of the interview I got question like what application object is and where we will use application object in asp.net.

What are the Differences between ASP.NET 3.5 and ASP.NET 4.0 | What are new features in Asp.net 4.0

Introduction

Here I will explain about differences between Asp.net 3.5 and Asp.net 4.0. 

Description

In previous post I explained differences between asp.net 1.0 and asp.net 2.0 and in another post I explained differences between asp.net 2.0 and asp.net 3.5 . Now I will explain about differences between asp.net 3.5 and asp.net 4.0.

What are the Differences between asp.net 1.0, asp.net 1.1 and asp.net 2.0

Here I will explain about differences between asp.net 1.0, 1.1 and 2.0 versions. 

Asp.net 1.0 & 1.1 version

In these Asp.net versions IIS should be installed by user.  

Asp.net 2.0 version

In this version IIS comes along with dotnet installation no need to install separately and in Asp.net 2.0 many new features has came into picture like partial classes, master pages, skins and themes, roles and membership profiles, Generics and many new controls etc. I will explain each feature clearly. Main purpose of Asp.net 2.0 is used to increase productivity, use same controls for all types of devices, faster and better web application.

what are the Difference between ASP.NET 2.0 and ASP.NET 3.5 | Multi Targeting in asp.net | what are the Asp.net 3.5 features

Here I will explain about differences between asp.net 2.0/3.0/3.5. Generally we will see the questions like difference between Asp.net 2.0, 3.0 and 3.5 but there is no Asp.net 3.0 version. We have a version of 3.0 .NET Framework.

Interview Questions Part-7 | What is a deadlock in SQL Server | What are “GRANT” and “REVOKE’ statements in SQL | How do you find the Second highest Salary in SQL Server

What is a deadlock in SQL Server?

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.

Interview Questions Part-6 | What is @@ROWCOUNT in SQL | What is Difference between Commit and Rollback in SQL | What is Candidate key, alternate key and composite key in SQL | What are Isolation Levels in SQL | What is Lock Escalation in SQL Server

What is the Use of @@ROWCOUNT?

Returns the number of rows affected by the Query.

Ex:

UPDATE authors SET au_lname = 'Jones'

WHERE au_id = '999-888-7777'

IF @@ROWCOUNT = 0

print 'Warning: No rows were updated'

Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?

What is PRIMARY KEY Constraint in SQL Server?

Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)

Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server

What is the Difference between a HAVING clause and a WHERE clause in SQL Server? 

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query

Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server

What is an Index in SQL Server?

An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)

Interview Questions Part-2 | What are the Different Types of Triggers | What is a View | What is the Difference between a Function and a Stored Procedure | What are the Advantages of Using Stored Procedures in SQL Server

What are the Different Types of Triggers?

After triggers and Instead of triggers 

After triggers are the triggers which are raised before the transaction committed or postback.

Instead of triggers are used to update the database tables which are associated with view instead of updating the view directly.

Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server

What is Normalization? 

In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.There are three main normal forms, each with increasing levels of normalization:

what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server

Introduction:

Here I will explain about what is stored procedure is and advantages and disadvantages of stored procedures in sql server

Description:

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure