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 / vinay
a. None of the rows are locked
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How do I delete a table in database?
What is null indicator in cobol db2?
What is cursor with hold option in db2?
How can we retrieve the total number of records in RPG & CLLE?
How do I change the column size in db2?
B37 abend during spufi?
How to retrieve rows from a db2 table in embedded sql?
Why do chiropractors use drop table?
How and when does the db2 enforces the unique key?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a db2 table?
What is bufferpool in db2?
Is db2 free?
Explain correlated sub-queries.