A locking protocol is one that ____________

A. Governs how locks are acquired
B. Governs how locks are released
C. Governs how locks are acquired and released
D. None of the mentioned

The two phase locking protocol consists of ____________

A. Growing & shrinking phase
B. Shrinking & creation phase
C. Creation & growing phase
D. Destruction & creation phase

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

The shrinking 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

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering

A. I only
B. Ii only
C. Both i and ii
D. Neither i nor ii