Recent questions tagged two-phase-locking-protocol / GATE Overflow for GATE CSE

1 votes

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}$

Which of the following statements about the Two Phase Locking ($2 \mathrm{PL}$) protocol is/are TRUE?$2 \mathrm{PL}$ permits only serializable schedulesWith $...

Arjun

2.0k views

Arjun asked Feb 16

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: -

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', respectiv...

GO Classes

742 views

GO Classes asked Feb 5

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.

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

gateexplore

209 views

gateexplore asked Jun 30, 2023

0 votes

0 answers

4

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

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

anupamsworld

411 views

anupamsworld asked Jul 26, 2022

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

In conservative two phase locking protocol, a transactionShould release all the locks only at the beginning of transactionShould release exclusive locks only after the co...

admin

2.8k views

admin asked Mar 30, 2020

0 votes

1 answer

6

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

Is basic 2 phase locking always recoverable?

Hirak

593 views

Hirak asked Jun 10, 2019

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$

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'...

aditi19

1.1k views

aditi19 asked May 28, 2019

1 votes

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

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 fo...

Applied Course

1.0k views

Applied Course asked Jan 16, 2019

0 votes

2 answers

9

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

Please explain. Use the below transaction.

susgir2

1.6k views

susgir2 asked Jan 4, 2019

1 votes

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

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

srestha

1.2k views

srestha asked Jul 28, 2018

0 votes

1 answer

11

Strict 2pl

Na462

1.4k views

Na462 asked Jul 14, 2018

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

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 proto...

bts

1.2k views

bts asked Jun 30, 2018

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

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 $2...

Na462

805 views

Na462 asked May 26, 2018

1 votes

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??

We know, Conservative 2PL is another name of Strict 2PL. But According to Navathe bookConservative 2PL is deadlock free,but Strict 2PL can have deadlock.Then how both cou...

srestha

4.0k views

srestha asked Jan 26, 2018

1 votes

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)

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)...

Tuhin Dutta

1.9k views

Tuhin Dutta asked Aug 13, 2017

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?

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...

shashank023

5.9k views

shashank023 asked Jul 25, 2017

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true