Answer to Question #266621 in Databases | SQL | Oracle | MS Access for Prem

Question

Write short notes on Recoverability. 

Answer 1

Recoverability is the process in which certain transaction is getting fail due to the failure of the system or suppose any transaction is going on but suddenly there is power cut or short circuit happen into the system or there may be some natural accicens gets happen then in that case the transaction may get interrupted then there is a option to recover that failure or recover the transaction failure and rollback the things then the process is known as the recoverability.

$S_1: R_1(x),W_1(x),R_2(x),R_1(y),R_2(y),W_2(x),W_1(y),C_1,C_2;$

Herre, $T_i->T_j=>C_1->C_2$

We can say that $T_1$ is executed before the transaction $T_2$ , hence there is no chance of conflict occur.