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 if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


What information is held in SYSIBM.SYSCOPY?

1 Answers  


What is the difference between nvl and coalesce?

0 Answers  


Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,


How do I delete a column in db2?

0 Answers  


What is a collection?

3 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


How do I delete a table in db2?

0 Answers  


How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,


What is release/acquire in bind?

0 Answers  


Give the COBOL definition of a VARCHAR field.

2 Answers  


Categories