Q. To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.

View solution

Q. Redo operations are performed exclusively using

View solution

Q. Which of the following is used for undo operations alone ?

View solution

Q. Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called

View solution

Q. If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is

View solution

Q. A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site.This is

View solution

Q. A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is

View solution

Q. A _______________ configuration can make takeover by the backup site almost instantaneous.

View solution

Q. The time to process the remote backup can be reduced by

View solution

Q. The simplest way of transferring control is for the old primary to receive __________ from the old backup site.

View solution

Q. When the __________ the backup site takes over processing and becomes the primary.

View solution

Q. The backup is taken by

View solution

Q. Remote backup system must be _________ with the primary site.

View solution

Q. The remote backup site is sometimes also called the

View solution

Q. Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.

View solution

Q. ______________ rolls back all transactions that were incomplete at the time of crash.

View solution

Q. __________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.

View solution

Q. ___________ determines which transactions to undo,which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.

View solution

Q. The __________________ contains a list of pages that have been updated in the database buffer.

View solution

Q. There are special redo-only log records generated during transaction rollback, called _________ in ARIES.

View solution