a. None of the rows are locked

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.

Question Posted / vinay

3 Answers
9186 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

Please Help Members By Posting Answers For Below Questions

Explain in brief how does db2 determine what lock-size to use?

987

How can the duplicate values be eliminated from db2 select?

1064

Outputs of explain are with matchcols = 0. What does this signify?

1011

What is a buffer in memory?

1021

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2182

What is the latest version of ibm db2?

1223

Who uses db2?

996

What is the use of value function?

1095

What is a plan and package in db2?

1062

How would the varchar column remarks defined?

1046

What is database reorganization?

1077

What is explain plan in db2?

949

what is a corelated subquerry?

1081

What are the various data types available in db2?

1032

What is db2 optimizer?

1201