Dark Mode

Recent questions tagged conflict-serializable

0 votes

1 answer

61

UGC NET CSE | July 2018 | Part 2 | Question: 65
Consider the following schedules involving two transactions. $S_1 : r_1(X) ; r_1(Y); r_2(X); r_2(Y); w_2(Y); w_1(X)$ $S_2 : r_1(X) ; r_2(X); r_2(Y); w_2(Y); r_1(Y); w_1(X)$ Which one of the following statements is correct ... not conflict serializable $S_1$ is not conflict serializable and $S_2$ is conflict serializable

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.5k views

2 votes

1 answer

62

View Serializability
Consider the following schedules: Which of the following is correct about above schedule? Only view serializable Only conflict serializable Both conflict and view serializable Neither view serializable nor conflict serializable. Please tell me the approach for checking view serializability ?

Na462 asked in Databases May 29, 2018

by Na462

1.5k views

9 votes

1 answer

63

Are aborted transactions ALWAYS ignored when determining result/view/conflict serializability?
I am looking for some clarity on this topic. Here is some random schedule as an example: $r1(x) w1(x) r2(x) w2(x) r3(y) r3(x) w3(x) c3 a1 c2$ I was told, that for ... , strictness or avoidance of cascading rollbacks. I would be grateful if the question would be answered since this really confuses me.

flow2539 asked in Databases May 28, 2018

3.4k views

0 votes

1 answer

64

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

766 views

1 vote

1 answer

65

Transaction
how view serializability ensures serial schedule?? i mean in view we leave many conflict like RW,WW,......we only talks about WR conflict and intial read and final write. then how it ensurs serailizability??

Ravi prakash pandey asked in Databases Apr 10, 2018

by Ravi prakash pandey

308 views

0 votes

1 answer

66

Databases
How to find number of conflict equivalent schedules possible :)

gauravkc asked in Databases Feb 1, 2018

568 views

2 votes

0 answers

67

Ace Test Series: DBMS - Transaction And Serializablity
Answer given is 24 which is the no. of serial schedules possible, but my doubt is since no two transactions share same variables then all the schedules possible will be conflict serializable then why only serial schedules are considered ?

ashish pal asked in Databases Jan 26, 2018

462 views

2 votes

1 answer

68

Conflict Serializable
It is not conflict serializable, So, why not option A) ??

srestha asked in Databases Jan 24, 2018

811 views

2 votes

0 answers

69

Concurrency Control
Which of the following statement is true? 1. time stamp protocol may not result recoverable schedule 2. in 2PL, No data are affected until all locks are obtained i.e., until the transaction is in its locked point. a) only a b) only b c) a and b d) none

hacker16 asked in Databases Jan 18, 2018

1.3k views

1 vote

0 answers

70

Precedence graph
Consider 2 schedules S1 and S2 with same set of transactions and precedence graph of S1 is same as precedence graph of S2. Which of the following statement is True? (a) Both S1 and S2 are conflict equal and conflict serializable schedule (b) Both S1 and S2 ... and S2 are conflict equal but may not equal schedules (d) Both S1 and S2 are conflict equal and but may not view equivalent

hacker16 asked in Databases Jan 18, 2018

1.1k views

2 votes

4 answers

71

Conflict serializability

Balaji Jegan asked in Databases Jan 17, 2018

by Balaji Jegan

1.8k views

2 votes

2 answers

72

Database question : Transactions

thepeeyoosh asked in Databases Jan 9, 2018

1.4k views

1 vote

0 answers

73

Conflict Serializable
Two transaction T1 and T2 are given as follows T1: R1(A),W1(A),R1(B),W1(B) T2: R2(B),W2(B),R3(C),W3(C) Number of conflict serializable be ____________

srestha asked in Databases Jan 3, 2018

531 views

3 votes

1 answer

74

Conflict equivalent
Find the number of conflict equivalent schedule: $r_{1}\left ( x \right ),w_{1}\left ( y \right ),w_{1}\left ( z \right ) , r_{2}\left ( x \right ),w_{2}\left ( y \right ),w_{2}\left ( z \right )$

srestha asked in Databases Jan 3, 2018

1.2k views

1 vote

0 answers

75

Conflict equivalent

Anup patel asked in Databases Dec 26, 2017

421 views

1 vote

0 answers

76

2 PL with lock upgrade and Conflict serializability
Hi Guys, Please tell following statement is T/F --> If there is a schedule which is conflict serializable. But there may not exist any 2 PL with lock upgrade scheme to execute it. PS: ping @Krish__, @rahul sharma 5, @Red_devil, @Shivam Chauhan, @Tuhin Dutta, @Anu007, @Ashwin Kulkarni @reena_kandari and @srestha ji.

Chhotu asked in Databases Dec 26, 2017

by Chhotu

936 views

0 votes

1 answer

77

Transactions & Concurrency Control
The above question has a blind write so it should be View Serializable. But can it be Conflict Serializable?

Kaustubh _15 asked in Databases Dec 15, 2017

by Kaustubh _15

482 views

0 votes

0 answers

78

Ace Test Series: Databases - Conflict Serializable
Serializable: Conflict or View?

saxena0612 asked in Databases Dec 13, 2017

384 views

2 votes

1 answer

79

Abhijeet_Kumar asked in Databases Dec 8, 2017

by Abhijeet_Kumar

372 views

3 votes

1 answer

80

Abhijeet_Kumar asked in Databases Dec 8, 2017

by Abhijeet_Kumar

580 views

4 votes

0 answers

81

Abhijeet_Kumar asked in Databases Dec 8, 2017

by Abhijeet_Kumar

408 views

2 votes

1 answer

82

Conflict and View serializable

Parshu gate asked in Databases Dec 5, 2017

960 views

1 vote

1 answer

83

Ace Test Series: Databases - Conflict Serializable
conflict serialization or not? $R1(A), R2(A),W2(A),commit_2,W1(A) ,commit_1$

aaru14 asked in Databases Oct 29, 2017

by aaru14

378 views

2 votes

0 answers

84

shivangi5 asked in Databases Oct 16, 2017

395 views

1 vote

2 answers

85

Doubt Question on Transaction schedules
Consider a Serial Schedule given- T1 T2 T3 w1(A) w1(B) r2(A) w2(B) r3(A) w3(B) How many schedules which are view equivalent to above schedule? How many schedules which are confilct equivalent to above schedule? ... serializable/ view serializable? If yes How many serial schedules are possible which are conflict equivalent/ view equivalent to able schedule?

Durgesh Singh asked in Databases Sep 30, 2017

by Durgesh Singh

891 views

1 vote

1 answer

86

Test by Bikram | Databases | Test 2 | Question: 28
Given below are some transaction schedules that involve three transactions $T1 \ T2 \ T3$: $\textbf{Schedule 1:}$ $T2 : Rx , T2 : Ry , T1 : Wx , T3 : Wy , T3 : Wz , T2 : Wz , T1 : Rz , T2 : Wy $ ... $1$ Schedule $2$ Schedule $3$ Schedule $4$

Bikram asked in Databases Aug 26, 2017

by Bikram

274 views

3 votes

2 answers

87

Test by Bikram | Databases | Test 2 | Question: 17
Which of the following is TRUE about the given schedule S? ... is conflict serializable. It is view serializable but not conflict serializable. It is conflict serializable but not view serializable. It is not serializable.

Bikram asked in Databases Aug 26, 2017

by Bikram

481 views

1 vote

2 answers

88

#Transaction-Schedules
How to order these schedules in terms of flexibility of concurrency? 1. View serializable 2. Conflict Serializable 3.Recoverable 4.Strict 5.Cascadeless

Tuhin Dutta asked in Databases Aug 12, 2017

689 views

0 votes

3 answers

89

CONFLICT SERIALIZABLE
What is the answer?

learner_geek asked in Databases Jun 21, 2017

by learner_geek

528 views

1 vote

1 answer

90

dbms, concurrency control
Can a schedule ( s) be irrecoverable and conflict serializable at same time?

Ashish Mishra 4 asked in Databases Jun 14, 2017

by Ashish Mishra 4

588 views

Page:

Recent questions tagged conflict-serializable