The growing phase is a phase in which?
A)a transaction may obtain locks, but does not release any
B)a transaction may obtain locks, and releases a few or all of them
C)a transaction may release locks, but does not obtain any new locks
D)a transaction may release locks, and does obtain new locks

Question

Quizplus · Accepted Answer

In the growing phase of a transaction, it can obtain locks but does not release any. This is part of the two-phase locking protocol which ensures serializability in database systems. The protocol consists of two phases: the growing phase, where locks are acquired and not released, and the shrinking phase, where locks are released and no new locks are acquired.

The Growing Phase Is a Phase in Which