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
tableTransaction IDTime,Action,Record Updated,Sofore lnngeAfter lmage:Start,,,:Start,,,:Insert,ServiceRequest new values:Start,,,:Update,Location old valuesnew values:Update,Owner FEold valuesnew values:Commit,s:Start,,,:Update,CondoUnit old valuesnew values:Commit,,,:Update,CondoUnit old valuesnew values:Commitat,,,:Update,CondoUnit old valuesnew values:Update,Owner FEold valuesnew values:Commit,,,
a Suppose a catastrophe destroys the database just after : 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 : 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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
