DB Foundations Checkpoint

1. The WAL rule requires:

Log records reach stable storage before the page is flushed Pages are flushed before logging Logs and pages are flushed together No logging for committed txns

2. Steal/no-force means:

Dirty pages may be written before commit and commits need not flush pages Pages are never written before commit Commits always flush all pages No WAL is required

3. PageLSN is used to:

Avoid reapplying updates during redo Track free space Encode record lengths Pick eviction victims

4. True/False: WAL is sufficient to recover from crashes under steal/no-force.