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.

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 use of db2?

586


What is db2 connect?

607


What is the physical storage length of the data types date, time, and timestamp?

608


What is the difference between db2 and oracle?

677


What r the comman abends in db2, jcl and cobol???????

1818






What is the maximum number of columns in a db2 table?

723


What kind of database is db2?

572


What is dbrm?

643


How does a cursor work?

555


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

10772


What is sqlca’s maximum length?

674


What is the syntax for FETCH in DB2 ?

674


What is meant by union and union all?

585


Why cursor is used in db2?

572


How to run db2 command in windows?

648