Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Transactions
|
Question 83
|
Immediate updates as a recovery protocol is preferable, when :
|
Database reads more than writes
|
|
|
Writes are more than reads
|
|
|
It does not matter as it is good in both the situations
|
|
|
There are only writes
|
Question 83 Explanation:
→ Immediate updates as a recovery protocol is preferable when writes are more than reads.
→ In this technique, when a transaction issues an update command, the database on disk can be updated immediately, without any need to wait for the transaction to reach its commit point.
→ In this technique, when a transaction issues an update command, the database on disk can be updated immediately, without any need to wait for the transaction to reach its commit point.
Correct Answer: B
Question 83 Explanation:
→ Immediate updates as a recovery protocol is preferable when writes are more than reads.
→ In this technique, when a transaction issues an update command, the database on disk can be updated immediately, without any need to wait for the transaction to reach its commit point.
→ In this technique, when a transaction issues an update command, the database on disk can be updated immediately, without any need to wait for the transaction to reach its commit point.