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
- 7889 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 is buffer pool and list some of them?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the use of db2?
What is alias in db2?
What is the result of open cursor statement?
What r the comman abends in db2, jcl and cobol???????
What is dpf in db2?
what is the role of the cursor in db2?
What is the use of with ur in db2?
Explain the contention situations caused by locks?
What is universal database?
What is precompiler in db2?
What is the latest version of ibm db2?
What is the use of predicate?
Is ibm db2 open source?
