What is "Locking" concept in DBMS?

 Posted by Abhisek on 7/27/2010 | Category: Sql Server Interview questions | Views: 15656

Locking is the most common type of concurrency control mechanism. In this approach, any data is retrieved by an active user for updating, must be locked or denied to other users until updating is not complete.

Locking is of three types,
1> Shared Lock(S)
2> Exclusive Lock(X)
3> Dead Lock(D)

Source: Exam Question | Asked In: Many Exams | Alert Moderator 

Comments or Responses

Login to post response