a. none of the rows are locked. Thanks; Amita Sharma.

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 / amita sharma

3 Answers
9314 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / amita sharma

a. none of the rows are locked.

Thanks;
Amita Sharma.

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by dclgen?

1101

What is alias in db2?

1051

How does db2 sample database connect?

1024

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3150

What os does db2 run on?

973

Which isolation level provides maximum concurrency?

1150

What is a page in db2?

1025

What is bind and rebind in db2?

1133

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1233

Define declaration generator (dclgen).

1108

List out the data types available.

1147

Why do chiropractors use drop table?

1101

what is the role of the cursor in db2?

1060

What is commit in db2?

1046

What is the difference between using bind () and rebind () methods of naming class?

1389