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 difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

Can you access the DB2 Directory table using SQL?

3 Answers  

What is db2 bind process?

0 Answers  

how to unload different table data into different gdg files/ vsam files.

3 Answers  

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

What is drop table?

0 Answers  

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

What does an outer join do?

1 Answers   CTS,

What happens to a cursor after a commit?

3 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

Explain about rct in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories