Which of the following isolation levels will lock all rows scanned to build a result data set?
A. Uncommitted Read
B. Cursor Stability
C. Read Stability
D. Repeatable Read
Question 2
For which two of the following database objects can locks NOT be acquired ?
A. Buffer pools
B. Tablespaces
C. Tables
D. Rows
E. Columns
Question 3
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?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Question 4
A transaction is using the Repeatable Read isolation level. A table is scanned twice within the same transaction. Which of the following can be seen the second time the table is scanned?
A. The same rows that were seen the first time the table was scanned
B. Rows added to a result set by other processes
C. Rows changed in a result set by other processes
D. Rows with uncommitted changes made by other processes
Question 5
A transaction is using the Read Stability isolation level. Which of the following releases an Update (U) lock that has been acquired by the transaction?
A. When the cursor accessing the row is closed
B. When the transaction executes a COMMIT statement
C. When the cursor accessing the row is moved to the next row
D. Immediately after the UPDATE statement is executed
Question 6
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?
A. SHARE MODE
B. ISOLATED MODE
C. EXCLUSIVE MODE
D. RESTRICT MODE
Question 7
A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?
A. Uncommitted changes made by other transactions can be seen from one scan to the next.
B. Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.
C. Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.
D. Rows that have been updated can be changed by other transactions from one scan to the next.
Question 8
A database contains a read-only lookup table. In order to provide optimum read concurrency, transactions accessing this table should be run using which of the following isolation levels?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Question 9
An application is bound to a database using the Repeatable Read isolation level. A transaction within the application issues a request that retrieves 100 rows out of 10,000 in the table. Which of the following describes the rows that are locked as a result of this request?
A. None of the rows are locked.
B. All rows scanned are locked.
C. All rows returned to the result data set produced are locked.
D. The last row accessed is locked.
Question 10
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?
