Enrollments closing soon for Post Graduate Certificate Program in Applied Data Science & AI By IIT Roorkee | 3 Seats Left
Apply NowTwo processes, salary credit process (SCP) and interest credit process (ICP), were updating the same row of a table.
SCP credited a person's account with 1000 to increase it from 2000 to 3000 for the month's salary.
Before SCP could commit this change, ICP read the uncommitted value, added 1% interest credit of 30 to the account to make it 3030 and committed the change.
SCP whose processing was not done yet, added a further allowance of 100 to the account in lieu of employee's overtime time to make it 3130 and committed the change. So, this amount of 100 left unprocessed by ICP.
Which database transaction property got violated in this case?
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
Loading comments...