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 / 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 maximum length of sqlca?

869


Why do chiropractors use drop table?

660


Outputs of explain are with matchcols = 0. What does this signify?

617


Define predicate?

643


How to execute stored procedure in db2 command editor?

532






What are db2 objects?

641


Is db2 free?

684


How to find the maximum value in a column in the db2 database?

611


What is the difference between plan and package in db2?

572


What is ibm db2 used for?

601


Is db2 a programming language?

606


Can we update view in db2?

560


What language is db2 written in?

595


How is deadlock resolved?

650


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

658