Application A issues the following SQL statements within in a single transaction using the
Uncommitted Read isolation level:
SELECT * FROM employee WHERE deptno=’A00′;
UPDATE employee SET salary = salary * 1.1 WHERE deptno=’A00′;
As long as the transaction has not been committed, which of the following is true for all other
applications not running under the Uncommitted Read isolation level?

If an application issues the same query more than once in the same Unit of Work, which isolation
level will not permit this application to see additional rows inserted by other applications?

60 Which of the following best describes how locks are used in DB2?

If DB2 detects a deadlock between application A and application B (each waiting for a lock held by
the other one), what action will DB2 take?

How does DB2 protect the integrity of indexes when data is updated?

Application A currently holds an exclusive lock on a single row and application B tries to access
that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the
following will occur?

Which of the following resources can be referenced in the LOCK statement?

If application A issues the following SQL statement, which of the following statements about
concurrency is true?
SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = ‘A00’ FOR READ ONLY
WITH RS

Which of the following best describes the lock protection provided by DB2 for the current row of a
cursor?

Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?