Dark Mode

Recent questions tagged two-phase-locking-protocol

1 vote

1 answer

1

GATE CSE 2024 | Set 2 | Question: 17
Which of the following statements about the Two Phase Locking ($2 \mathrm{PL}$) protocol is/are TRUE? $2 \mathrm{PL}$ permits only serializable schedules With $2 \mathrm{PL}$, a transaction always locks the data item being read or ... , no more locks on any data item can be obtained inside that transaction A deadlock is possible with $2 \mathrm{PL}$

Arjun asked in Databases Feb 16

by Arjun

1.7k views

9 votes

1 answer

2

GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 41
Consider the following lock requests in the Table below. And note that: $\mathrm{S}(\cdot)$ and $\mathrm{X}(\cdot)$ stand for 'shared lock' and 'exclusive lock', respectively. $T_1, T_2, T_3, T_4$, and $T_5$ represent five ... dead('-'). Select all that are correct. At t3: a At t6: b At t7: a At t8: -

GO Classes asked in Databases Feb 5

664 views

0 votes

0 answers

3

Databases
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.

gateexplore asked in Databases Jun 30, 2023

202 views

0 votes

0 answers

4

Doubt
Does Conservative 2 Phase Locking Protocol ensures no Deadlock? Please describe your answer.

anupamsworld asked in Databases Jul 26, 2022

by anupamsworld

395 views

2 votes

3 answers

5

NIELIT 2017 DEC Scientist B - Section B: 18
In conservative two phase locking protocol, a transaction Should release all the locks only at the beginning of transaction Should release exclusive locks only after the commit operation Should acquire all the exclusive locks at the beginning of transaction Should acquire all the locks at the beginning of transaction

admin asked in Databases Mar 30, 2020

by admin

2.7k views

0 votes

1 answer

6

DBMS: SELF DOUBT .
Is basic 2 phase locking always recoverable?

Hirak asked in Databases Jun 10, 2019

by Hirak

584 views

0 votes

0 answers

7

Virtual Gate Test Series: Databases - Schedules
A' is set of all possible schedules 'C' is set of all possible schedules that are guaranteed to produce a correct final result 'S' is the set of all serializable schedules 'P' is the set of all schedules possible under 2-phase locking protocol Which is FALSE? $P\subseteq C$ $S\subset P$ $S\subseteq P$ $P\subset C$

aditi19 asked in Databases May 28, 2019

1.0k views

1 vote

1 answer

8

Applied Course | Mock GATE | Test 1 | Question: 59
Consider the following interleaved schedule with two transactions T1 and T2. The Two-Phase Locking Protocol is followed for achieving concurrency control. Which of the following statements is true with respect to the given schedule? The ... ; T2 The schedule results in a deadlock The schedule is not permitted as per Two Phase Locking Protocol

Applied Course asked in Databases Jan 16, 2019

by Applied Course

957 views

0 votes

2 answers

9

How Strict 2PL avoids unrepeatable read problem?
Please explain. Use the below transaction.

susgir2 asked in Databases Jan 4, 2019

1.6k views

1 vote

1 answer

10

Two Phase Locking
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it

srestha asked in Databases Jul 28, 2018

1.2k views

0 votes

1 answer

11

Na462 asked in Databases Jul 14, 2018

by Na462

1.4k views

0 votes

1 answer

12

Two phase locking and time stamp
Which of the following is correct ? I.Two phase locking is an optimistic protocol. II. Two phase locking is pessimistic protocol III. Time stamping is an optimistic protocol. IV. Time stamping is pessimistic protocol. A I and III B II and IV C I and IV D II and III

bts asked in Databases Jun 30, 2018

by bts

1.2k views

0 votes

1 answer

13

Transaction
Consider the following schedule: Which of the following is correct about above schedule? $Schedule(S)$ is not conflict serializable schedule. $Schedule(S)$ is allowed by $2PL$. $Schedule(S)$ is strict recoverable schedule. $Schedule(S)$ is allowed by strict $2PL$. Reason Please

Na462 asked in Databases May 26, 2018

by Na462

762 views

1 vote

1 answer

14

Strict and Conservative 2PL
We know, Conservative 2PL is another name of Strict 2PL. But According to Navathe book Conservative 2PL is deadlock free,but Strict 2PL can have deadlock. Then how both could be same??

srestha asked in Databases Jan 26, 2018

4.0k views

1 vote

1 answer

15

Two-Phase-Locking
Sort these various versions of Two Phase locking protocols in increasing order of restricted-ness: 1. 2-PL(normal) 2. S-2PL(Strict) 3. R-2PL(Rigorous) 4. C-2PL (Conservative) 5. LC-2PL(Lock Conversion)

Tuhin Dutta asked in Databases Aug 13, 2017

1.9k views

4 votes

1 answer

16

conservative two phase locking protocol
Does the conservative two phase locking protocol produce cascadeless schedules? Let us consider the following schedule : Since in the schedule the lock on a is released, it is possible for the transaction T2 to acquire the lock on a. ... Does it mean that even though a conservative two phase protocol is used, the schedules may not necesssarily be cascadeless?

shashank023 asked in Databases Jul 25, 2017

5.8k views

To see more, click for the full list of questions or popular tags.

Recent questions tagged two-phase-locking-protocol