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 / amita sharma
a. none of the rows are locked.
Thanks;
Amita Sharma.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to check table size in db2 sap?
What are union and union all?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is db2 stogroup?
What is null value in db2?
Can you use max on a char column?
What is the maximum size of a char data type in db2?
Mention the location where the output received from explain statement is stored.
What are db2 tables?
what is diffrence b/w file-aid tool and file-aid utility???
i want to maintain uniqueness on pdf without make lf??????????
Describe major components of db2?
How can you do the explain of a dynamic sql statement?
Which components manage deadlocks in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE