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
- 9307 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hussain
b. the retrieved rows are locked
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
Which component is responsible for db2 startup and shutdown?
What does a deadlock mean in DB2?
What is view db2?
Why cursor is used in db2?
How to access db2 tables in mainframe?
What is the purpose of rollback and commit?
How connect db2 database to datastage?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What language is db2 written in?
What is the information associated with sysibm.syslinks table?
what is a corelated subquerry?
What is sqlca?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a db2 package?
What is the use of reorg in db2?
