SQL Tutorial

59 / 68

Two 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?

Note - Having trouble with the assessment engine? Follow the steps listed here

Loading comments...