Q 9,paper 3,j 12. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.

Option (A) Temporary Select Problem (B) Temporary Modify Problem (C) Dirty Read Problem (D) None
Answer © Dirty read problem.
Explanation .Problems due to the Concurrent Execution of Transactions • The Lost Update Problem( updates made by the transaction are overwritten by another transaction hence earlier updates are lost.) • The Incorrect Summary or Unrepeatable Read Problem(Suppose a user wants the summarized information and when the summarized onformation for the all tuples is under process another user make change in tuples. So we get a summarized information with some old data and some changed data.) • The Temporary Update (Dirty Read) Problem.( A user ‘A ‘changes some data and this changed data is used by another user B. Now user A Rolls back but B user has already read the data which was changed temporarily by user A and not commited to it.)