Question: Given the log with four transactions on Solmaris database shown below, answer questions table [ [ Transaction ID , Time,Action,Record Updated,Sofore lnnge , After

Given the log with four transactions on Solmaris database shown below, answer questions
\table[[Transaction ID,Time,Action,Record Updated,Sofore lnnge,After lmage],[1,10:00,Start,,,],[2,10:01,Start,,,],[1,10:02,Insert,ServiceRequest (14),,(new values)],[3,10:03,Start,,,],[2,10:04,Update,Location (2),(old values),(new values)],[3,10:05,Update,Owner (FE182),(old values),(new values)],[1,10:06,Commit,s,,],[4,10:07,Start,,,],[3,10:08,Update,CondoUnit (5),(old values),(new values)],[3,10:09,Commit,,,],[2,10:10,Update,CondoUnit (5),(old values),(new values)],[2,10:11,Commitat,,,],[4,10:12,Update,CondoUnit (5),(old values),(new values)],[4,10:13,Update,Owner (FE182),(old values),(new values)],[4,10:14,Commit,,,]]
a. Suppose a catastrophe destroys the database just after 10:07. Which transactions would the recovery program use to update the restored backup? Which transactions would have to be requested by the users again? Why?
b. Suppose a catastrophe hang up the database just after 10:09. All data are not affected but the database program stopped running. After restart, which transactions would the recovery program roll back? Why?
c. At this moment there is NO deadlock in the database. Can you reorder some of the steps in the log to create a deadlock? Which transactions will be involved in the deadlock?
Given the log with four transactions on Solmaris

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!