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