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

how to check the table is empty or not?

3 Answers   IBM,

What is buffer pool and list some of them?

0 Answers  

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

What is an alias and how does it differ from a synonym?

3 Answers  

what is db2 restart?

0 Answers  

what is datacom db?

2 Answers   CSC,

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

How is the value function used?

0 Answers  

How do I change the column size in db2?

0 Answers  

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

How would one remove old reorg information from the DB2 catalog?

2 Answers  

For more DB2 Interview Questions Click Here
Categories