Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the                field of the page.

Related MCQs

• 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.
• The log is a sequence of                     recording all the update activities in the database.
• Writing the buffered log to                      is sometimes referred to as a log force.
• A transaction commits 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
• 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
• ARIES uses a                        to identify log records, and stores it in database pages.
•                        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.
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.