Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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 / chandra

Answers were Sorted based on User's Feedback



4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / amita sharma

a. none of the rows are locked.

Thanks;
Amita Sharma.

Is This Answer Correct ?    8 Yes 1 No

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / vinay

a. None of the rows are locked

Is This Answer Correct ?    6 Yes 2 No

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retr..

Answer / hussain

b. the retrieved rows are locked

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More DB2 Interview Questions

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

wht are the restrictions for union ?

2 Answers   CTS,

What is the purpose of the DSNC transaction ?

1 Answers  

Define db2 and its databases?

0 Answers  

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

What is copy pending status in db2?

0 Answers  

What is db2 command?

0 Answers  

Give some example of statistics collected during RUNSTATS?

1 Answers  

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

What is netezza database?

0 Answers  

What is the difference between spufi and qmf?

0 Answers  

For more DB2 Interview Questions Click Here
Categories