Week8 - Transaction Recovery, Save Points / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

1. The simplest way of transferring control is for the old primary to receive redo logs from the old backup site, and to catch up with the updates by applying them locally.

Question 1
__________has both primary and backup sites are active.

(a) two-very-safe

Question 2
Undo of an incomplete transaction writes out special redo-only log records, and an abort log record.

(a) TRUE

Question 3
Transaction processing is based on a storage model in which main memory holds …........

(a) a log buffer
(b) a database buffer
(c) a system buffer

Question 4
Efficient implementation of a recovery scheme requires that the number of writes to the database and to stable storage be __________.

(c) minimized

Question 5
After lower-level locks are released, physical _____ is not possible.

(a) undo