b. the retrieved 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 / hussain

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

Please Help Members By Posting Answers For Below Questions

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053

What is a db2 cursor?

1004

What are host variables in db2?

991

What is the difference between db2 and oracle?

1067

What is the difference between dbm cfg and db cfg file in db2 ?

1477

What are types of indexes?

997

Define data page.

1011

Explain about dbrm.

987

What is load replace in db2?

935

What's The Error Code For Unique Index Voilation?

1152

what is diffrence b/w file-aid tool and file-aid utility???

4809

How can we read records for specific member in CL? AND rpg?

643

What is the max length of sqlca?

1156

what is utility for parm lib

2308

Mention the location where the output received from explain statement is stored.

1053