Latest DBMS Aptitude Question SOLUTION: What are different types of two phase lockings (2pl)?

• Placement Papers
• /
• DBMS

DBMS Question Papers:

(#M40030381) DBMS question DBMS Keep an EYE

What are different types of two phase lockings (2pl)?

Asked In DBMS MAN (10 years ago)

Unsolved Read Solution (4)

Is this Puzzle helpful?   (1)   (0) Submit Your Solution

Read Solution (4) :

Sarvjeet Rajvansh  (9 years ago)

Growing



















Growing Phase : Transaction may obtain locks , but may not release any lock.
Shrinking Phase : Transaction may release locks, but may not obtain any new locks.

Is this solution Helpfull? Yes (1) | No (1)  

mishu  (8 years ago)

In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability.[1][2] It is also the name of the resulting set of database transaction schedules (histories). The protocol utilizes locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data during the transaction's life.

By the 2PL protocol locks are applied and removed in two phases:

Expanding phase: locks are acquired and no locks are released.
Shrinking phase: locks are released and no locks are acquired.

Is this solution Helpfull? Yes (1) | No   

sruthi  (9 years ago)

Strict two phase locking
Strong strict two phase locking

Is this solution Helpfull? Yes | No (1)  

Nishant  (9 years ago)

expending,shrinking

Is this solution Helpfull? Yes | No   

Please Login to Read Solution.