IBM Certification Question:
Download Questions PDF

Suppose an application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
A.No row lock is acquired when the row is updated.
B.The row lock is released when the cursor accessing the row is closed.
C.The row lock is released when the application issues a COMMIT statement.
D.The row lock is released when the cursor accessing the row is moved to the next row.

Answer:

C.The row lock is released when the application issues a COMMIT statement.

Download IBM Certification Interview Questions And Answers PDF

Previous QuestionNext Question
The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.		When Disk space for a table is allocated in one or more units called what?

A. tblspaces
B. extents
C. blobs
D. chunks