4. A DB2 application is bound with uncommitted Read
isolation level.It issues a request that retrieves 20 rows
out of 200000 in the table.
Which of the following descrbes the rows that are locked
as a result of this request?
a. None of the rows are locked.
B.The retrieved rows are locked.
C.The last row of the result set is locked.
D.The rows not previously updated by another application
are locked.
Answer Posted / hussain
b. the retrieved rows are locked
Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
What is the maximum No of rows per page?
What is the purpose of rollback and commit?
How many types of page locks can be held in db2?
What is reorg and runstats in db2?
What is db2?
How to run db2 command in windows?
How is a typical db2 batch pgm executed?
What is the use of runstats in db2?
Explain about mirror activator disk mirroring?
What is package in db2 mainframe?
What is reorg?
What is iseries database?
what are bind concepts in db2 cobol?
Which isolation level provides maximum concurrency?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.