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.

Answers were Sorted based on User's Feedback



4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / amita sharma

a. none of the rows are locked.

Thanks;
Amita Sharma.

Is This Answer Correct ?    8 Yes 1 No

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / vinay

a. None of the rows are locked

Is This Answer Correct ?    6 Yes 2 No

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / hussain

b. the retrieved rows are locked

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More DB2 Interview Questions

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


How to handle null values in db2

4 Answers  


what is cursor stability?

2 Answers   IBM,


What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


what is plan? is plan executable or package?

4 Answers  


how can i pull up a query which was previously stored in qmf

3 Answers  


How to see the structure of db2 table??

4 Answers   IBM,


what are the bind parameters?

5 Answers   IBM,


Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  


Categories