Shared lock or read lock, Database Management System

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.

 

Posted Date: 3/12/2013 2:37:42 AM | Location : United States







Related Discussions:- Shared lock or read lock, Assignment Help, Ask Question on Shared lock or read lock, Get Answer, Expert's Help, Shared lock or read lock Discussions

Write discussion on Shared lock or read lock
Your posts are moderated
Related Questions
Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency

Operator Precedence The basic operators used in SQL are * /   - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit

Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy.  b. Domain constraints, functional dependency

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

does tables are called relations

What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A)     Begin transaction B)      End transaction

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie