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
9337 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

What is the difference between drop table and delete table?

1214

What is cloudant database?

1103

Where do you specify them?

1289

Explain packages.

1116

What type of database is db2?

971

What is node in db2?

1049

What does runstats do in db2?

1123

Explain what are the various isolation levels possible?

1044

How do I delete a column in db2?

1112

Define check constraint.

1083

Explain package in db2 and its advantages?

1219

What is the advantage in De-normalizing tables in DB2?

1181

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

What is the difference between nvl and coalesce?

1065

What is the use of commit in db2?

1083