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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is phantom read in db2?
What is db2 catalog database?
What is scrollable cursor in db2?
What are catalog tables in db2?
What is the role of union all and union
Mention the location where the output received from explain statement is stored.
what is the role of the cursor in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the use of with ur in db2?
What is database alias db2?
What is the result of open cursor statement?
What is nvl in db2?
How to test SQL -911 error while developing COB-DB2 program
What is db2 connect?