Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Transactions
|
Question 87
|
Which of the following statements is wrong ?
|
2-phase Locking Protocols suffer from dead locks.
|
|
|
Time – Stamp Protocols suffer from more aborts.
|
|
|
Timestamp Protocols suffer from cascading rollback where as 2-phase locking Protocol donot.
|
|
|
None of these
|
Question 87 Explanation:
2-Phase locking: It provides a serializable schedule but does not provides a deadlock free serializable schedule. Deadlock might occur using this concurrency control mechanism.
Time Stamp Protocol: It suffers more aborts in comparison of other concurrency control protocols because of allowing the execution of the transactions based upon their time stamp ordering. A transaction with higher timestamp is allowed to execute otherwise if a transaction with lower timestamp requests for execution then in that case that transaction will be aborted.
Time Stamp Protocol: It suffers more aborts in comparison of other concurrency control protocols because of allowing the execution of the transactions based upon their time stamp ordering. A transaction with higher timestamp is allowed to execute otherwise if a transaction with lower timestamp requests for execution then in that case that transaction will be aborted.
Correct Answer: C
Question 87 Explanation:
2-Phase locking: It provides a serializable schedule but does not provides a deadlock free serializable schedule. Deadlock might occur using this concurrency control mechanism.
Time Stamp Protocol: It suffers more aborts in comparison of other concurrency control protocols because of allowing the execution of the transactions based upon their time stamp ordering. A transaction with higher timestamp is allowed to execute otherwise if a transaction with lower timestamp requests for execution then in that case that transaction will be aborted.
Time Stamp Protocol: It suffers more aborts in comparison of other concurrency control protocols because of allowing the execution of the transactions based upon their time stamp ordering. A transaction with higher timestamp is allowed to execute otherwise if a transaction with lower timestamp requests for execution then in that case that transaction will be aborted.