Q$\mathrm{.}2$Set. $($A$)$

i$)$ Consider the following code and Find out the what type of $2$PL locking is used:

a$)$

Lock$\_$S$($basic$)$

Lock$\_$X$($netsal$)$

Lock$\_$S$($deduct$)$

Lock$\_$X$($hra$)$

R$($Basic$)$

$R($deduct$)$

Hra$-$hra$\_$hra$*0\mathrm{.}5$

Netsal $=$ basic $-$deduct $+$hra

Unlock$($basic$)$

Unlock$($deduct$)$

W$($netsal$)$

W$($hra$)$

Commit

Unlock $($netsal$)$

Unlock$($hra$)$

b$)$

Lock$\_$s$($A$)$

$R(A)$

Lock$\_$X$($B$)$

$B=A+B$

Unlock$($B$)$

Unlock$($A$)$