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
9350 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 the physical storage length of the data types date, time, and timestamp?

1096

What is the purpose of using commit?

1104

What is concurrency?

1243

How do I start db2 in windows?

1105

Which components manage deadlocks in db2?

1075

What is the role of data manager in the db2 database?

1112

What are the two types of logging in the db2 database? Explain them.

1084

What is release/acquire in bind?

1114

What is with ur in db2?

1331

What are union and union all?

991

Which isolation level provides maximum concurrency?

1160

What are the different types of base tables?

1103

Is schema the same as database?

1070

What is lock escalation in db2?

1042

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1086