SQL stands for structured query language. It is a database language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database.

In SQL Server a view is a virtual table which contains a subset of data within a table. Views are not virtually present, and it takes less space to store.

A foreign key is a field or a column that is used to establish a link between two tables. This is sometimes also called as a referencing key.

The UNIQUE Constraint prevents two or more records from having identical values in a column. A UNIQUE key column can allow one NULL values. A table can have multiple UNIQUE key.

A primary key is a field in a table which uniquely identifies each row/record in a database table. Primary keys must contain unique values.

View State is the method to preserve the Value of the Page and Controls between round trips. It is a Page-Level State Management technique.

The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the view, and the controller. The ASP.NET MVC framework provides an alternative to the ASP.NET Web Forms pattern for creating inactive Web applications.

Response.Write() and Response.Output.Write() both are used for print output on the screen.

what is Difference between Primary Key and Unique Key.

Page 3 of 4