Can database Backup & Recovery from Catastrophic Failure is provided how? Illustrate with an example and possible recovery techniques.

0

Can database Backup & Recovery from Catastrophic Failure is provided how? Illustrate with an example and possible recovery techniques.

0

practice503

Asked: November 2, 2021In: DBMS

Consider the following two transactions: T31: Read(A) Read (B) if A=0 then B=B+1 Write (B) T32: Read(B) Read (A) if B=0 then A=A+1 Write (A) Add lock and unlock instructions to transactions T31 and T32 so that they observe the two phase protocol. Can the execution of these transaction results in a deadlock.

0

Consider the following two transactions: T31: Read(A) Read (B) if A=0 then B=B+1 Write (B) T32: Read(B) Read (A) if B=0 then A=A+1 Write (A) Add lock and unlock instructions to transactions T31 and T32 so that they observe the two phase protocol. Can the execution of these transaction ...