What are the different types of Locks

 Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 2339

Mainly There are three types of locks in SQL Server :

(1)Shared locks are used for operations that does not allow to change or update data, such as a SELECT statement.
(2)Update locks are used when SQL Server intends to modify a page, and later promotes the update page lock to an exclusive page lock before actually making the changes.
(3)Exclusive locks are used for the data modification operations, such as UPDATE, INSERT, or DELETE.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response