The LSN stored in a page of the database refers to an update record in the log describing the most recent update to the page. Suppose that a transaction has performed the last update to a page and later aborts. Since its update to the page is reversed, the LSN in the page no longer refers to the appropriate update record. Why is this not a problem in the description of logging in the text?
What will be an ideal response?
When the update is reversed, a compensation log record is written to the log and its LSN is recorded in the page. Since the UNDO can be viewed as simply another write, the page’s LSN is correct.
You might also like to view...
You may replace the space in a Web folder or file name with CamelCase, hyphen, or ________
Fill in the blank(s) with correct word
Evaluate the formula of conversion of Fahrenheit to Celsius 
, if 
.
A. 
B. 
C. 
D. 
E. 
You are working with a customer who is using Chef configuration management in their data center. Which service is designed to let the customer leverage existing Chef recipes in AWS?
A. Amazon Simple Workflow Service B. AWS Elastic Beanstalk C. AWS CloudFormation D. AWS OpsWorks
All recursive methods must have a/an:
(a) starting case (b) intermediate case (c) stopping case (d) none of the above