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
- 7934 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is deadlock in db2?
How to retrieve rows from a db2 table in embedded sql?
What is alias in db2?
What types of tables are there in the db2 database?
What is buffer pool in the db2 database?
How do you find the maximum value in a column in db2?
Which is faster delete or truncate?
When do you specify the isolation level?
What is the clustering index in the db2 database?
Explain about dbrm.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What happens in bind step in a db2 program?
What is schema in db2?
What is a db2 collection?
what is the responsibility of the construction superintendent
