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?

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?

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?

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?

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

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?

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