Shared lock or read lock, Database Management System

Assignment Help:

Shared lock or Read Lock

  • It is requested by a transaction that needs to just read the value of data item.
  • A shared lock on a data item does not permit an exclusive lock to be placed but allows any number of shared locks to be placed on that item.

 


Related Discussions:- Shared lock or read lock

Heuristics, Benefits of using heuristics

Benefits of using heuristics

Log, what is the need of a log in dbms

what is the need of a log in dbms

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Define outer union operation of the relational algebra, Define outer union ...

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Attributes and tuple, Before we talk about the relational model in more det...

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

Answer, what is database management system? & why it is required?

what is database management system? & why it is required?

What is a recovery scheme, What is a recovery scheme? An integral part ...

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Example of grant create session to mca12, Example -GRANT CREATE SESSION TO ...

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

What is the full form of odbc, What is the full form of ODBC ? ODBC stand...

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd