Question: i ) Consider the following code and Find out the what type of 2 PL locking is used: a ) Lock _ S ( basic

i) Consider the following code and Find out the what type of 2PL locking is used:
a) Lock_S(basic)
Lock_X(netsal)
Lock_S(deduct)
Lock_X(hra)
R(Basic)
R(deduct)
Hra-hra_hra*0.5
Netsal = basic -deduct +hra
Unlock(basic)
Unlock(deduct)
W(netsal)
W(hra)
Commit
Unlock (netsal)
Unlock(hra)
 i) Consider the following code and Find out the what type

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!