Under strict two-phase locking: (i) Exclusive locks are held until com — PYQDeck

PyQdeckBEU PYQ Archive Subjects

Back to the 2025 paper

Module 4: Transaction Processing

20252m

Under strict two-phase locking:

(i) Exclusive locks are held until commit/abort
(ii) Deadlocks are impossible
(iii) Locks can be released anytime
(iv) Transactions become serial

Search Google Ask AI

Similar questions

DATABASE MANAGEMENT SYSTEMExplain two-phase locking protocol & conflict serializability. | Unit 3 – Transaction Management | Concurrency control.20247m DATABASE MANAGEMENT SYSTEMShow that the two-phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.202114m Database Management SystemWhat is two-phase locking protocol? Explain its working in detail. How can it guarantee serializability?20197m DATABASE MANAGEMENT SYSTEMSerializability of concurrent transaction is ensured by - (i) locking - (ii) time stamping - (iii) both (a) and (b) - (iv) none of these20232m

PreviousConsider the schedule: R1(X), R2(X), W1(X), W2(X). The schedule is: (i) View serializable only (ii) Conflict serializable (iii) Not serializable (iv) Recoverable NextExplain the three-level database architecture with a neat diagram. How does it support data abstraction and data independence?