CISC 3140 STUDY GUIDE 2026 QUESTIONS
WITH ANSWERS GRADED A+
>> Database Recovery
Answer: Restore after crash
>> Redo
Answer: Re-apply committed changes
>> Undo
Answer: Roll back uncommitted changes
>> ARIES
Answer: Algorithm for recovery
>> WAL
Answer: Write-Ahead Logging
>> Checkpoint
Answer: Point where all changes are on disk
>> Log Sequence Number (LSN)
Answer: Unique log entry ID
>> Redo Log
Answer: Records committed changes
WITH ANSWERS GRADED A+
>> Database Recovery
Answer: Restore after crash
>> Redo
Answer: Re-apply committed changes
>> Undo
Answer: Roll back uncommitted changes
>> ARIES
Answer: Algorithm for recovery
>> WAL
Answer: Write-Ahead Logging
>> Checkpoint
Answer: Point where all changes are on disk
>> Log Sequence Number (LSN)
Answer: Unique log entry ID
>> Redo Log
Answer: Records committed changes