Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock?

Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock? Correct Answer Time stamp ordering

According to the 2PL protocol, a transaction handles its locks in two distinct, consecutive phases during the transaction's execution:

Expanding phase: locks are acquired and no locks are released (the number of locks can only increase).

Shrinking phase: locks are released and no locks are acquired.

2PL ensures conflict serializability but does not ensure deadlock freedom.

But time stamp ordering ensures both deadlock freedom and conflict serializabilty.

Related Questions

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I. 2-phase locking II. Time-stamp ordering
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering
Consider the following two statements about database transaction schedules: I. Strict two-phase locking protocol generates conflict serializable schedules that are also recoverable. II. Timestamp-ordering concurrency control protocol with Thomas’ Write Rule can generate view serializable schedules that are not conflict serializable. Which of the above statements is/are TRUE?
Which of the following is/are the advantages of using a control chart for inspection? (i) A control chart indicates whether the process is in control or out of control. (ii) A control chart determines process variability. (iii) A control chart ensures product quality. (iv) Scrap or percentage reduction can be reduced by taking the necessary actions in time against the warnings indicated by control charts. (v) Control charts build up the reputation of the organization through customer’s satisfaction. (vi) The control chart can detect the unusual variations taking place in a process.
Which of the following statements is/are true/false regarding modes of Conflict Management Styles?
1. The avoidance modes of conflict management aim at avoiding or postponing conflicts.
2. The compromise mode involves coercion and is likely to fail to reach a solution.
3. The main objective of the defusion mode of conflict resolution is to buy time for dealing with a conflict.
4. Withdrawal is a form of approach mode that involves getting away from a conflict situation.
Which of the following protocols ensures conflict serializability and safety from deadlocks?
In the following question, sentences of a paragraph have been jumbled and labelled as A, B, C and D. You are required to rearrange the jumbled sentences of the paragraph and mark your response accordingly by selecting the correct option. A: This particular operation was given the code name Operation Safed Sagar. B: The Kargil War, also known as the Kargil conflict, was an armed conflict between India and Pakistan that took place between May and July 1999 in the Kargil district of Kashmir and elsewhere along the Line of Control (LOC). C: The Indian Air Force's role in acting jointly with Indian Army ground troops during the war was aimed at flushing out regular and irregular troops of the Pakistani Army from vacated Indian Positions in the Kargil sector along the Line of Control. D: In India, the conflict is also referred to as Operation Vijay, which was the name of the Indian operation to clear the Kargil sector.
Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
Consider the following three statements about link state and distance vector routing protocols, for a large network with 500 network nodes and 4000 links. [S1] The computational overhead in link state protocols is higher than in distance vector protocols. [S2] A distance vector protocol (with split horizon) avoids persistent routing loops, but not a link state protocol. [S3] After a topology change, a link state protocol will converge faster than a distance vector protocol. Which one of the following is correct about S1, S2, and S3?
Whenever you have a hardware resource conflict, it will more likely be an IRQ conflict rather than an i/o conflict because: