Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for transactions
1
votes
2
answers
1
UGC NET CSE | June 2023 | Part 2: 44
Which one of the following is $\text{NOT}$ a part of $\text{ACID}$ properties of a database transaction? Atomicity Consistency Isolation Deadlock-freedom
Which one of the following is $\text{NOT}$ a part of $\text{ACID}$ properties of a database transaction?AtomicityConsistencyIsolationDeadlock-freedom
admin
279
views
admin
asked
Jul 28, 2023
Databases
ugcnetcse-june2023-paper2
databases
transactions-and-concurrency-control
+
–
0
votes
1
answer
2
Casecading rollback in WD and WW
Is the possibility of cascading rollbacks more in Wound and Wait or in Wait Die?
Is the possibility of cascading rollbacks more in Wound and Wait or in Wait Die?
Tara33
265
views
Tara33
asked
Dec 25, 2022
Databases
transactions-and-concurrency-control
+
–
0
votes
0
answers
3
Serializability
What is Proof/Explanation for complexity to test if a schedule is conflict serializable is O(n^2) whereas for view serializable is O(2^n)-Exponential ?
What is Proof/Explanation for complexity to test if a schedule is conflict serializable is O(n^2) whereas for view serializable is O(2^n)-Exponential ?
SakarKoot
237
views
SakarKoot
asked
Sep 4, 2022
Databases
transactions-and-concurrency-control
conflict-serializable
view-serializable
+
–
6
votes
1
answer
4
GATE Overflow Test Series | Mock GATE | Test 4 | Question: 58
Consider the following schedule $\textbf{Schedule}$ ... The number of view equivalent serial schedules of the given schedule is ________
Consider the following schedule$$\textbf{Schedule}$$$$\begin{array}{|c|c|c|}\hlineT_{1} & T_{2} & T_{3}\\\hlineR(x) & &\\\hline& R(x) &\\\hlineW(y) & & \\\hline& &R(x)\\\...
gatecse
513
views
gatecse
asked
Feb 1, 2021
Databases
go2025-mockgate-4
numerical-answers
databases
transactions-and-concurrency-control
+
–
0
votes
1
answer
5
UGC NET CSE | October 2020 | Part 2 | Question: 48
In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if At least one of the operations is write operation Both the operations are performed on the same data item Both the operations are performed by different transactions Both ... and $(c)$ only $(a)$, $(c)$ and $(d)$ only $(c)$ and $(d)$ only
In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule ifAt least one of the operations is write operationBoth the op...
go_editor
1.2k
views
go_editor
asked
Nov 20, 2020
Databases
ugcnetcse-oct2020-paper2
databases
transactions-and-concurrency-control
+
–
2
votes
3
answers
6
NIELIT 2018-36
______ is NOT a part of the ACID properties Inconsistency Consistency Atomicity Isolation
______ is NOT a part of the ACID propertiesInconsistencyConsistencyAtomicityIsolation
Arjun
968
views
Arjun
asked
Dec 7, 2018
Databases
nielit-2018
databases
transactions-and-concurrency-control
+
–
2
votes
1
answer
7
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 17
Consider the following schedule $\textbf{Schedule}$ ... $a,$ the value of $2^a = $ ________
Consider the following schedule$$\textbf{Schedule}$$$$\begin{array}{|c|c|c|c|c|c|} \hline T_{1} & T_{2} & T_{3} & T_{4} \\\hline R(x) & & & \\ & R(x) & & \\ & & R(x) & \...
gatecse
213
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
numerical-answers
transactions-and-concurrency-control
+
–
2
votes
1
answer
8
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 18
Which of the following is/are correct with respect to $2$-phase locking $\text{(2PL)}$? (Mark all the appropriate options) $\text{2PL}$ always ensures serializability, but cascading rollbacks, deadlocks and starvation are ... be serialized in the order in which they commit Every conservative $\text{2PL}$ is rigorous $\text{2PL}$
Which of the following is/are correct with respect to $2$-phase locking $\text{(2PL)}$? (Mark all the appropriate options)$\text{2PL}$ always ensures serializability, but...
gatecse
146
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
2
votes
1
answer
9
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 12
Dr. Unnikrishnan did a UPI transaction to book a bus ticket on his mobile phone and as soon as he received a success confirmation his phone battery died and the phone tuned off. If that was the last ticket ... assigned the ticket and after contacting the customer care one of their ticket gets cancelled and he gets a refund
Dr. Unnikrishnan did a UPI transaction to book a bus ticket on his mobile phone and as soon as he received a success confirmation his phone battery died and the phone tun...
gatecse
94
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
1
votes
2
answers
10
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 5
Which of the following is/are correct? (Mark all the appropriate options) Every cascadeless schedule is a recoverable schedule. Every recoverable schedule is a cascadeless schedule. Every strict schedule is a cascadeless schedule. Every cascadeless schedule is a strict schedule.
Which of the following is/are correct? (Mark all the appropriate options)Every cascadeless schedule is a recoverable schedule.Every recoverable schedule is a cascadeless ...
gatecse
72
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
1
votes
1
answer
11
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 16
Consider the following schedules $\textbf{First Schedule}$ ... orderings of the precedence graph of the schedule. Otherwise, let $b = 0.$ The value of $a + b + (a\times b) = $ ________
Consider the following schedules$$\textbf{First Schedule}$$$$ \begin{array}{|c|c|c|} \hline T_{1} & T_{2} & T_{3} \\\hline R(A) & & \\ & & R(A) \\ W(A) & & \\ & R(A) &...
gatecse
111
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
numerical-answers
transactions-and-concurrency-control
+
–
1
votes
1
answer
12
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 19
Which of the following is/are correct with respect to concurrency control of database transactions? (Mark all the appropriate options) There are schedules common to both $\text{2PL}$ and time-stamp based protocol Basic time- ... protocol There are schedules that can be produced by basic time-stamp based protocol but not $\text{2PL}$
Which of the following is/are correct with respect to concurrency control of database transactions? (Mark all the appropriate options)There are schedules common to both $...
gatecse
109
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
1
votes
1
answer
13
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 13
If there are $n$ transactions each having $m_{1},m_{2},\dots,m_{n}$ ...
If there are $n$ transactions each having $m_{1},m_{2},\dots,m_{n}$ operations respectively, the number of concurrent schedules possible is ______ (Mark all the appropria...
gatecse
95
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
1
votes
1
answer
14
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 14
Consider $4$ transactions $T_{1},T_{2},T_{3}$ and $T_{4}$ having $1,4,2$ and $3$ operations respectively. If $a$ is the total number of serial schedules and $b$ is the total number of concurrent schedules then the total number of non-serial schedules, $c = b – a = $ _______
Consider $4$ transactions $T_{1},T_{2},T_{3}$ and $T_{4}$ having $1,4,2$ and $3$ operations respectively. If $a$ is the total number of serial schedules and $b$ is the to...
gatecse
98
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
numerical-answers
transactions-and-concurrency-control
+
–
1
votes
1
answer
15
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 15
Which of the following is/are correct? (Mark all the appropriate options) In a Serial schedule, a transaction is executed completely before starting the execution of another transaction. In a Strict schedule, if ... transaction then this transaction can commit only after the commit of other transaction which is updating the value.
Which of the following is/are correct? (Mark all the appropriate options)In a Serial schedule, a transaction is executed completely before starting the execution of anoth...
gatecse
65
views
gatecse
asked
Oct 15, 2020
Databases
go2025-mix-3
transactions-and-concurrency-control
multiple-selects
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register