Question: ( i ) Suppose the same database instance as above and SQL statements shown below: UPDATE Catalog SET cost = cost * 0 . 9
i Suppose the same database instance as above and SQL statements shown below: UPDATE Catalog SET cost cost WHERE sid
UPDATE Catalog SET cost cost WHERE sid
When we use READ COMMITTED on the SQL statements above, an unrepeatable read could occur resulting in an incorrect value being assigned to cost But this problem cannot occur when we use REPEATABLE READ.
Suppose the same database instance as above and SQL statements shown below assuming READ UNCOMMITTED can write to the database:
UPDATE Catalog SET cost cost SELECT Csid, Cpid FROM Catalog C WHERE Ccost
When we use READ UNCOMMITTED on the SQL statements above, dirty read of the value of cost could occur because the first SQL statement might not be finished while the second one is reading. But this problem cannot occur when we use READ UNCOMMITTED.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
