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?

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)?

Application A is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno=’000010′
UPDATE department SET deptname = ‘NEW dept’ WHERE deptno=’A00′
Application B is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE department SET deptname = ‘OLD DEPT’ WHERE deptno=’A00′
UPDATE employee SET salary = salary * 0.5 WHERE empno=’000010′
Application A and application B execute their first SQL statement at the same time. When
application A and application B try to execute their second SQL statement, a deadlock occurs.
What will happen?

Application A holds an Update lock on a single row and application B is trying to read that row. If
both applications are using isolation level UR, which of the following will occur?