Exam Practice Question 8 Consider the following transaction, Ti, on the Package Delivery database: Begin; Update Package Set Date Delivered = '30-Nov-09 Where TrackingNumber = TR1678'; Update Package Delivery Set Delivery Status = 'Delivered Where Tracking Number = 'TRI678' And ShippingCenterld = POS44; Commit; Show the entries that would be made in the Transaction Log if transaction TI executed successfully (ii) Using T1 as an example, explain the Write-ahead logging protocol for writing the records to the Transaction log and to the database files. Assume an immediate-write environment. (iii) Suppose that the update to the Package Delivery table failed because of a Referential Integrity error on ShippingCenterld. Show what would be recorded in the transaction log in this case. Explain how the Recovery Manager will recover from this transaction failure and restore the database to a consistent state. Exam Practice Question 8 Consider the following transaction, Ti, on the Package Delivery database: Begin; Update Package Set Date Delivered = '30-Nov-09 Where TrackingNumber = TR1678'; Update Package Delivery Set Delivery Status = 'Delivered Where Tracking Number = 'TRI678' And ShippingCenterld = POS44; Commit; Show the entries that would be made in the Transaction Log if transaction TI executed successfully (ii) Using T1 as an example, explain the Write-ahead logging protocol for writing the records to the Transaction log and to the database files. Assume an immediate-write environment. (iii) Suppose that the update to the Package Delivery table failed because of a Referential Integrity error on ShippingCenterld. Show what would be recorded in the transaction log in this case. Explain how the Recovery Manager will recover from this transaction failure and restore the database to a consistent state