Which of the following DB2 UDB isolation levels will only lock rows during read processing if
another transaction tries to drop the table the rows are being read from?

Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen
when Application B attempts to acquire a compatible lock on the same row?

To which of the following resources can a lock NOT be applied?

Which of the following causes a lock that is being held by an application using the Cursor Stability
isolation level to be released?

An application has acquired a Share lock on a row in a table and now wishes to update the row.
Which of the following statements is true?

Which of the following modes, when used with the LOCK TABLE statement, will cause the DB2
Database Manager to acquire a table-level lock that prevents other concurrent transactions from
accessing data stored in the table while the owning transaction is active?

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?

Application A wants to read a subset of rows from table TAB1 multiple times. Which of the
following isolation levels should Application A use to prevent other users from making
modifications and additions to table TAB1 that will affect the subset of rows read?

A table contains a list of all seats available at a football stadium. A seat consists of a section
number, a seat number, and whether or not the seat has been assigned. A ticket agent working at
the box office generates a list of all unassigned seats. When the agent refreshes the list, it should
only change if another agent assigns one or more unassigned seats. Which of the following is the
best isolation level to use for this application?

Which of the following resources can be explicitly locked?