How many types of locks are there, Database Management System

Depending upon the rules we have found, we can classify the locks into two types.

Shared Lock: A transaction might be acquiring shared lock on a data item in order to read its content. The lock is shared in the sense that any other transaction can obtain the shared lock on that similar data item for reading purpose.

Exclusive Lock: A transaction might be acquiring exclusive lock on a data item in order to both read/write into it. The lock is excusive in the sense that no other transaction can acquire any type of lock (either shared or exclusive) on that similar data item.

 

Posted Date: 7/26/2013 7:07:26 AM | Location : United States







Related Discussions:- How many types of locks are there, Assignment Help, Ask Question on How many types of locks are there, Get Answer, Expert's Help, How many types of locks are there Discussions

Write discussion on How many types of locks are there
Your posts are moderated
Related Questions
Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio

How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

what is view?explain

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

In the architecture of a database system which external level used? In the architecture of a database system view external level used.

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

List and also explain the dissimilar stages of DDLC ?

What is transaction? Collections of operations that form a single logical unit of work are known as transactions.