Recent questions tagged transaction-and-concurrency

2 votes
2 answers
361
1 votes
2 answers
365
1 votes
1 answer
366
Usage of Preemption and Transaction Rollback prevents _____.Unauthorized usage of data fileDeadlock situationData manipulationFile pre-emption
0 votes
1 answer
368
A Transaction Manager is which of the following?Maintains a log of transactionsMaintains before and after database imagesMaintains appropriate concurrent controlAll of th...
12 votes
4 answers
370
What is the equivalent serial schedule for the following transactions? $\text{T}_1 - \text{T}_2 - \text{T}_3$$\text{T}_3 - \text{T}_1 - \text{T}_2$$\text{T}_2 - \text{T}_...
5 votes
2 answers
371
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time?Transaction logQuery languageRepo...
5 votes
3 answers
372
Which of the following is correct with respect to Two phase commit protocol?Ensures serializabilityPrevents DeadlockDetects DeadlockRecover from Deadlock
5 votes
3 answers
374
Which of the following is the highest isolation level in transaction management?SerializableRepeated ReadCommitted ReadUncommitted Read
23 votes
2 answers
376
Which one of the following is NOT a part of the ACID properties of database transactions?AtomicityConsistencyIsolationDeadlock-freedom
64 votes
6 answers
377
0 votes
2 answers
379
2 votes
1 answer
380
scheduleR(A) R(B) R(B) W(A) COMMIT R(C) R(B) W(C) W(B) R(A) R(C) COMMIT COMMITThe above scedule is -:a)conflict serializableb)recoverablec)cascadelessd)all ...
5 votes
3 answers
383
how many view equivalent serial schedules are possible for the given schedule s: w1(a) r2(a) w3(a) r4(a) w5(a) r6(a)a) 2b) 3c) 6d) 8
5 votes
1 answer
384
Is it Conservative 2 Phase locking (C2PL) ?T1LOCK-X (A)LOCK-S (B)R(A)R(B)W(A)UNLOCK (A)COMMITUNLOCK (B)
3 votes
4 answers
385
6 votes
1 answer
386
Consider the following Two Transactions.How many Cascadeless schedules are possible over $T1$ & $T2$ ?$32$ $42$ $51$ $52$
1 votes
1 answer
390