Register

Recent questions tagged conflict-serializable

114
views
0 answers
0 votes
Self Doubt relate to ER diagrams(Databases).
 In (https://gateoverflow.in/219555/number-of-tables) number of tables to be made was 4, merging E1 and E2 in one table, one for R3, and for E3 and ... , I am confused regarding when to merge tables and when to not, someone please help me 
User Avatar
181
views
0 answers
0 votes
(Transactions and Schedules in Databases)
Q.3(a): You are given the following schedules involving three transactions (T1, T2, T3) performing operations on database items (A, B, C, D): ... lock and unlock instructions to ensure they adhere to the two-phase locking protocol.
User Avatar
2.9k
views
1 answers
2 votes
GATE CSE 2024 | Set 1 | Question: 36
Consider the following read-write schedule $\text{S}$ over three transactions $T_{1}, T_{2}$, and $T_{3}$ ... $T_{3} T_{1} T_{2}$
User Avatar
348
views
1 answers
3 votes
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 33
Consider the following two schedules consisting to two transaction $\mathrm{T}_1$ and $\mathrm{T}_2$ :Which of the following is/are true about these ... $\mathrm{S}_2$ are neither conflict equivalent nor conflict serializable.
User Avatar
585
views
0 answers
4 votes
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 59
Which of the following statements is/are false?In a cascade-less schedule if a transaction $T_j$ read a data item written by transaction $T_i$ then the ... been produced using the $2 \mathrm{PL}$ locking protocol) is conflict-serializable.
User Avatar
479
views
1 answers
0 votes
Number of Conflict Serializable Schedules
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
User Avatar
238
views
0 answers
0 votes
Made easy DBMS
User Avatar
205
views
0 answers
0 votes
madeeasy workbook
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
User Avatar
776
views
1 answers
1 votes
GO Classes 2023 | IIITH Mock Test 1 | Question: 19
Assume by "Serializability", we mean "Conflict Serializability".For the given schedule, which of the following is TRUE?$\text{T}_1$\text{T}_2$\text{T}_3$ ... serial schedule $\text{T}_2, \text{T}_3, \text{T}_1, \text{T}_4$
User Avatar
Page: