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 the picture clause of the null indicator variable?

6 Answers  

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

What is a DBRM, PLAN ?

3 Answers  

When the like statement is used?

0 Answers  

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  

What is db2 and what is the use of db2 optimizer?

0 Answers  

Name the various locking levels available?

0 Answers  

What is the function of the Data Manager?

2 Answers  

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

When is the skeleton cursor table created?

1 Answers  

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

For more DB2 Interview Questions Click Here
Categories