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.