Question: Using a log-based recovery scheme might improve performance as well as provide a recovery mechanism by a. Writing the log records to disk when each

Using a log-based recovery scheme might improve performance as well as provide a recovery mechanism by

a. Writing the log records to disk when each transaction commits
b. Writing the appropriate log records to disk during the transaction’s execution
c. Waiting to write the log records until multiple transactions commit and writing them as a batch
d. Never writing the log records to disk

Step by Step Solution

3.28 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The correct answer is option a writing the log records to disk when each transaction commits Logbase... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Fundamentals Of Database Systems Questions!