Application A issues the following SQL statements within a single transaction using the
Uncommitted Read isolation level:
SELECT * FROM department WHERE deptno = ‘A00’;
UPDATE department SET mgrno = ‘000100’ WHERE deptno = ‘A00’;
As long as the transaction is not committed, which of the following statements is FALSE?
A.
Other applications not running under the Uncommitted Read isolation level are prohibited from
reading the updated row
B.
Application A is allowed to read data stored in another table, even if an Exclusive lock is held on
that table
C.
Other applications running under the Uncommitted Read isolation level are allowed to read the
updated row
D.
Application A is not allowed to insert new rows into the DEPARTMENT table as long as the
current transaction remains active
The Uncommitted Read (UR) isolation level, also known as “dirty read,” is the lowest level of isolation supported by DB2. It can be used to access uncommitted data changes of other applications.
0
0