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

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

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

959

What is dbrm? When it will be created?

956

Highlight all the advantages that are attached to a package.

1072

Is ibm db2 free?

953

what is the role of the cursor in db2?

1000

Is db2 free?

1036

What is db2 purescale?

943

How is the value function used?

1080

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2473

What is difference between rollback and commit?

1092

Which isolation level provides maximum concurrency?

1089

What are the uses of db2 optimizer?

1223

Give the name of some fields form sqlca.

1021

What is dclgen in db2?

1082