IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 4

Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

Answer options

• A. Read Stability
• B. Cursor Stability
• C. Repeatable Read
• D. Cursor Stability with WAIT FOR OUTCOME clause A

Correct answer:

Explanation

The correct answer is A. Read Stability, which allows a transaction to read committed data even if another transaction has an exclusive lock on that data. The other options, such as Cursor Stability and Repeatable Read, do not provide this level of access while respecting the locks held by other transactions.