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

Related MCQs

• 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
• A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
• A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called
•                          using a log record sets the data item specified in the log record to the old value.
• Writing the buffered log to                      is sometimes referred to as a log force.
• The                                policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
• Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the                field of the page.
• For a transaction to be durable, its changes need to be written to                  storage.
• The transaction log includes which of the following?
• In order to undo the work of transaction after last commit which one should be used?