Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged transaction-and-concurrency
3
votes
2
answers
181
Raghuramkrishnan
Tl:R(X), T1:R(Y), T1:W(X), T2:R(Y), T3:W(Y), Tl:W(X), T2:R(Y) is this schedule view serializable?
Tl:R(X), T1:R(Y), T1:W(X), T2:R(Y), T3:W(Y), Tl:W(X), T2:R(Y)is this schedule view serializable?
aditi19
561
views
aditi19
asked
Nov 16, 2018
Databases
databases
transaction-and-concurrency
serializability
+
–
0
votes
1
answer
182
Transaction self doubt
Is it recoverable and why?
Is it recoverable and why?
Shamim Ahmed
396
views
Shamim Ahmed
asked
Nov 13, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
0
answers
183
Serializable
smsubham
546
views
smsubham
asked
Nov 12, 2018
Databases
databases
transaction-and-concurrency
view-serializable
conflict-serializable
+
–
0
votes
0
answers
184
2 Phase Locking
https://gateoverflow.in/1484/gate1999-2-6 in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to acquire exclusive lock on B? and if T2 continues to acquire lock on B followed by T1 requesting for read and write lock on B successively, is it deadlock situation here? And is that why it is not 2PL?
https://gateoverflow.in/1484/gate1999-2-6in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to...
aditi19
436
views
aditi19
asked
Nov 11, 2018
Databases
-2phaselocking
databases
serializability
transaction-and-concurrency
+
–
0
votes
0
answers
185
GeeksforGeeks test Series.
Consider the following schedules: S1: r1(A); r1(B); w1(C); w2(D); w1(A); w2(A); r1(D); S2: r1(A); r1(B); r1(C); r1(D); w1(A); w2(B); w3(C); w4(D) Which of the following option is correct? S1 ... .com/questions/115435/what-is-meant-by-a-blind-write-in-a-schedule also implies that the blind writes are considered at transaction level in the schedule. Please confirm.
Consider the following schedules: S1: r1(A); r1(B); w1(C); w2(D); w1(A); w2(A); r1(D); S2: r1(A); r1(B); r1(C); r1(D); w1(A); w2(B); w3(C); w4(D) Which of the following o...
vinay chauhan
336
views
vinay chauhan
asked
Nov 11, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
3
answers
186
is conservative 2PL is recoverable
is conservative 2PL is recoverable schedule ?
is conservative 2PL is recoverable schedule ?
Gurdeep Saini
3.6k
views
Gurdeep Saini
asked
Nov 6, 2018
Databases
2phaselocking
transaction-and-concurrency
+
–
0
votes
0
answers
187
Self Doubt
In Log-Based Recovery why do we redo committed transactions?
In Log-Based Recovery why do we redo committed transactions?
jatin khachane 1
218
views
jatin khachane 1
asked
Nov 2, 2018
Databases
transaction-and-concurrency
+
–
0
votes
1
answer
188
number of conflict schedules
https://gateoverflow.in/178786/transaction can anyone confirm this question answer i am getting 90
https://gateoverflow.in/178786/transactioncan anyone confirm this question answer i am getting 90
sandygate
550
views
sandygate
asked
Nov 2, 2018
Databases
transaction-and-concurrency
+
–
0
votes
0
answers
189
Self doubt
Is this schedule is recoverable. Doubt : Here W(A) is BLIND WRITE in T1 ..does this make any difference T1 T2 W(A) R(A) COMMIT COMMIT
Is this schedule is recoverable.Doubt : Here W(A) is BLIND WRITE in T1 ..does this make any difference T1 T2W(A) R(A) COMMITCOMMIT
jatin khachane 1
252
views
jatin khachane 1
asked
Nov 1, 2018
Databases
transaction-and-concurrency
+
–
2
votes
1
answer
190
Self doubt
Which of the following are RECOVERABLE schedules
Which of the following are RECOVERABLE schedules
jatin khachane 1
623
views
jatin khachane 1
asked
Oct 31, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
1
answer
191
Testbook Test Series: Databases - Transactions
Let a schedule be strict recoverable schedule then it will suffer from which problem? 1.ww 2.rw 3.wr 4.lost update
Let a schedule be strict recoverable schedule then it will suffer from which problem? 1.ww2.rw3.wr4.lost update
Shukrayani
412
views
Shukrayani
asked
Oct 31, 2018
Databases
testbook-test-series
databases
transaction-and-concurrency
+
–
2
votes
0
answers
192
Dbms test1
i am finding difficulty in view serializable schedule please tell me how to check view serializablity with polygraph
i am finding difficulty in view serializable schedule please tell me how to check view serializablity with polygraph
Shivani gaikawad
990
views
Shivani gaikawad
asked
Oct 27, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
0
answers
193
#easy book
T1 T2 R(X) W(X) W(X) aborts commit find conflict serializability,view serializability, recoverable,cascadeless and strict schedule
T1T2R(X) W(X)W(X) abortscommit find conflict serializability,view serializability, recoverable,cascadeless and strict schedule
amit166
443
views
amit166
asked
Oct 26, 2018
Databases
databases
transaction-and-concurrency
and
concurrency
+
–
0
votes
1
answer
194
KORTH
T1 T2 T3 W(X) R(X) W(Y) W(X) R(Y) W(X) W(X) W(Y) W(X) W(Y) R(X) W(X) R(Y) W(Y) Number of blind write in given schedule
T1T2T3W(X) R(X) W(Y) W(X) R(Y) W(X) W(X) W(Y) W(X) W(Y) R(X) W(X) R(Y) W(Y) Number of blind write in given schedule
amit166
249
views
amit166
asked
Oct 26, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
2
answers
195
Transaction
Shivangi Parashar 2
438
views
Shivangi Parashar 2
asked
Oct 23, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
0
answers
196
Serializable Schedule
It's a question I already asked and correct answer is 2 but what's wrong with this approach help me :(
It's a question I already asked and correct answer is 2 but what's wrong with this approach help me :(
Na462
444
views
Na462
asked
Oct 18, 2018
Databases
databases
conflict-serializable
transaction-and-concurrency
+
–
0
votes
1
answer
197
Database-Transactions
Consider a database transaction involving two bank account x and y. read(x) x=x-50 write(x) read(y) y=y+50 write(y) Which of the following constraints fail if transaction fails after just after write(x) operation. (A)Atomicity (B)Durability (C ... in the Inconsistent state. Consistency should have been more appropriate here and hence (D) should have been the choice. Why (A).
Consider a database transaction involving two bank account x and y.read(x) x=x-50 write(x) read(y) y=y+50 write(y)Which of the following constraints fail if transaction f...
Ayush Upadhyaya
915
views
Ayush Upadhyaya
asked
Oct 12, 2018
Databases
databases
transaction-and-concurrency
+
–
5
votes
1
answer
198
Conflict Serializabilty
How many conflict equivalent schedules are possible for the given schedule ? $R_1(A), R_2(A), R_3(A), R_4(A), W_1(B), W_2(B), W_3(B), W_4(B)$
How many conflict equivalent schedules are possible for the given schedule ?$R_1(A), R_2(A), R_3(A), R_4(A), W_1(B), W_2(B), W_3(B), W_4(B)$
Hardik Maheshwari
975
views
Hardik Maheshwari
asked
Oct 10, 2018
Databases
databases
conflict-serializable
transaction-and-concurrency
+
–
0
votes
2
answers
199
Dbms transaction
Is in conservative 2pl we release the locks after it commit $\mathbf{or}$ locks can be released at any point of time and need not after commit operation ? Please Explain with example.
Is in conservative 2pl we release the locks after it commit $\mathbf{or}$locks can be released at any point of time and need not after commit operation ?Please Explain wi...
Prince Sindhiya
488
views
Prince Sindhiya
asked
Sep 11, 2018
Databases
transaction-and-concurrency
+
–
1
votes
1
answer
200
#self doubt
Let a schedule be Strict Recoverable then it will suffer from which problem? a) ww problem b) rw problem c)wr problem d) Lost update problem
Let a schedule be Strict Recoverable then it will suffer from which problem?a) ww problem b) rw problemc)wr problem d) Lost update problem
Shubham Aggarwal
2.4k
views
Shubham Aggarwal
asked
Sep 5, 2018
Databases
transaction-and-concurrency
+
–
0
votes
0
answers
201
transaction and concurrency control protocol
Consider th following schedule r1(A)r2(B)r3(C)w1(B)w2(C)w3(D) Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate last operation of each transaction
Consider th following scheduler1(A)r2(B)r3(C)w1(B)w2(C)w3(D)Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate...
gatecrack
379
views
gatecrack
asked
Sep 5, 2018
Databases
transaction-and-concurrency
databases
2phaselocking
2pl
+
–
1
votes
5
answers
202
transaction cascadeless
is this is cascadeless? r1(X),w2(X),w1(X), abort2, commit1
is this is cascadeless?r1(X),w2(X),w1(X), abort2, commit1
gatecrack
1.4k
views
gatecrack
asked
Sep 5, 2018
Databases
databases
transaction-and-concurrency
+
–
0
votes
0
answers
203
no. of schedule doubt
plz someone solve it
plz someone solve it
gatecrack
276
views
gatecrack
asked
Sep 3, 2018
Databases
databases
transaction-and-concurrency
scheduling
+
–
0
votes
0
answers
204
2pl protocol
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
Parimal Paritosh
403
views
Parimal Paritosh
asked
Sep 2, 2018
Databases
databases
transaction-and-concurrency
2phaselocking
conflict-serializable
+
–
1
votes
3
answers
205
ME TEST SERIES
HOW TO SOLVE THOSE TYPE OF QUESTION?
HOW TO SOLVE THOSE TYPE OF QUESTION?
Avik Chowdhury
1.2k
views
Avik Chowdhury
asked
Aug 30, 2018
Databases
transaction-and-concurrency
+
–
0
votes
1
answer
206
TESTBOOK TEST SERIES
IS THE GIVEN ANS RIGHT?
IS THE GIVEN ANS RIGHT?
Avik Chowdhury
369
views
Avik Chowdhury
asked
Aug 30, 2018
Databases
transaction-and-concurrency
+
–
1
votes
0
answers
207
Syllabus of Database management system
Are following part of gate syllabus for dbms? 1-Validation Based protocols 2-multiversion schemes 3-snapshot isolation 4-predicate reads(concurrency control) 5-concurrency in index structures.
Are following part of gate syllabus for dbms?1-Validation Based protocols2-multiversion schemes3-snapshot isolation4-predicate reads(concurrency control)5-concurrency in ...
bts1jimin
1.0k
views
bts1jimin
asked
Aug 27, 2018
Databases
syllabus
databases
transaction-and-concurrency
concurrency
+
–
1
votes
1
answer
208
Transaction & Concurrency control
Which of the following statement is/are incorrect? A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable. B: Checkpoint in schedules are inserted to ensure recoverability. (A) Only 1 (B) Only 2 (C) Both 1 and 2 (D) None
Which of the following statement is/are incorrect? A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B: Checkpoint...
Verma Ashish
2.0k
views
Verma Ashish
asked
Aug 25, 2018
Databases
transaction-and-concurrency
+
–
3
votes
4
answers
209
MADE EASY TEST SERIES
Consider the following schedules involving two transactions. $S_1 : R_1(x), W_2(y),R_2(x),W_1(y), \ commit_1, \ commit_2$ $S_2 : R_1(x), R_2(y),W_1(z), \ commit_1,R_3(y), R_3(z), W_2(y), W_3(x), commit_2, commit_3$ Which of the following ... S2 are allowed under 2PL B) only S1 is allowed under 2PL C) only S2 is allowed under 2PL D) neither S1 nor S2 is allowed under 2PL
Consider the following schedules involving two transactions.$S_1 : R_1(x), W_2(y),R_2(x),W_1(y), \ commit_1, \ commit_2$$S_2 : R_1(x), R_2(y),W_1(z), \ commit_1,R_3(y), R...
syncronizing
3.4k
views
syncronizing
asked
Aug 19, 2018
Databases
transaction-and-concurrency
+
–
0
votes
0
answers
210
Test Series
Question: Consider the following transactions: The number schedules of T1 and T2 recoverable are ________.
Question:Consider the following transactions:The number schedules of T1 and T2 recoverable are ________.
syncronizing
565
views
syncronizing
asked
Aug 19, 2018
Databases
transaction-and-concurrency
+
–
Page:
« prev
1
2
3
4
5
6
7
8
9
10
11
12
...
14
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register