View previous topic :: View next topic
|
Author |
Message |
gemini123 Currently Banned New User
Joined: 17 Jun 2008 Posts: 1 Location: hyderabad
|
|
|
|
1hi friends,
Can anyone suggest the answerS for the below question?
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. |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
when using UR none of the rows are locked ... UR will only lock rows during read processing if another transaction tries to drop the table the rows are being read from .. |
|
Back to top |
|
|
harikiran.mc
New User
Joined: 18 Jan 2007 Posts: 17 Location: CHENNAI
|
|
|
|
Answer
a. None of the rows are locked. |
|
Back to top |
|
|
|