Under the Strict Two-Phase Locking (Strict 2PL) pr...

IBPS RRB IT Officer Practice Questions - IBPS RRB IT Officer Scale II Specialist Officer Exam

Question Number 5

Under the Strict Two-Phase Locking (Strict 2PL) protocol, which of the following rules must be followed by a transaction?

It must release all locks only at the end of the transaction It must release all exclusive (write) locks only after the transaction commits or aborts It must acquire all locks before releasing any locks, and release shared locks after commit It must release shared locks before acquiring exclusive locks

✔ Correct Answer:

It must release all exclusive (write) locks only after the transaction commits or aborts

IBPS RRB IT Officer Practice Questions - IBPS RRB IT Officer Scale II Specialist Officer Exam

Question Number 5

Count Down:

Related questions :