Fundamental Rights |  UNESCO Intengible Cultural Heritage From India |  Corruption |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India | International Airports in India  | United Nation International Years National Highways | National Birds of Countries | 
Types of Speciation |  Unisexual and Bisexual Flowers |  DISANET |  National Child Labour Project Scheme |  Tropical Deciduous Forest |  Hoolock Gibbon: National Parks |  Sectors of Indian Economy |  How Legislative Council is Formed |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India |
Animals and their Baby Names |  Veto Power of President & Types of Veto |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in World

Search This Blog

The size of a lock is called:

  By GK Planet Team      
The size of a lock is called:
A. shared lock.
B. lock granularity
C. exclusive lock.
D. implicit lock.
Answer:A. shared lock.

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. The transaction does this by requesting a lock on the piece of data. Locks have different modes.

There are three lock modes:

SHARED
Row-level shared locks allow multiple users to read data, but do not allow any users to change that data.
Table-level shared locks allow multiple users to perform read and write operations on the table, but do not allow any users to perform DDL operations.

Multiple users can hold shared locks simultaneously.

EXCLUSIVE
An exclusive lock allows only one user/connection to update a particular piece of data (insert, update, and delete). When one user has an exclusive lock on a row or table, no other lock of any type may be placed on it.

UPDATE
Update locks are always row-level locks. When a user accesses a row with the SELECT... FOR UPDATE statement, the row is locked with an update mode lock. This means that no other user can read or update the row and ensures the current user can later update the row.
Shared locks exist when two transactions are granted read access. One transaction gets the shared lock on data and when the second transaction requests the same data it is also given a shared lock. Both transactions are in a read-only mode, updating the data is not allowed until the shared lock is released.
logoblog

Thanks for reading The size of a lock is called:

←Previous
« Prev Post
Next→
Next Post »

No comments:

Post a Comment

What you have to say about this?

Recent Posts ⌚

Video Lectures