Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9313 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vinay
a. None of the rows are locked
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the uses of db2 optimizer?
What are the various isolation levels possible?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the contents of a dclmgen?
what is the sqlcode -501
What is cursor with hold option in db2?
What is the result of open cursor statement?
How to check table size in db2 sap?
What is ibm db2 database?
What does reorg do in db2?
What is the usage of open cursor command?
How to create backup table in db2?
What is iseries database?
Highlight all the advantages that are attached to a package.
What is db2 command?
