Advanced
SQL
Q91 / 100
What is "write-ahead logging" (WAL) and why is it important for durability?
Correct! Well done.
Incorrect.
The correct answer is B) WAL requires that changes be recorded in a sequential log before being applied to the actual data files, so that after a crash the database can replay the log to recover committed transactions and undo uncommitted ones
B
Correct Answer
WAL requires that changes be recorded in a sequential log before being applied to the actual data files, so that after a crash the database can replay the log to recover committed transactions and undo uncommitted ones
Explanation
By writing changes to a durable log before modifying data pages, the database guarantees that committed transactions can be recovered (replayed from the log) even if a crash occurs before the data pages themselves were flushed to disk.
Progress
91/100