Show that two-phase locking protocol ensures conflict serializability and that transactions can be serialized according to their lock points with suitable examples.

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

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 ...