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

What is the difference between TYPE 1 index & TYPE 2 index

Question Posted / guest


What is the difference between TYPE 1 index & TYPE 2 index..

Answer / s

TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.

Is This Answer Correct ?    20 Yes 4 No

Post New Answer

More DB2 Interview Questions

What is pagespace?

1 Answers  

What is buffer pool?

0 Answers  

What is role in db2?

0 Answers  

How do I copy a table in db2?

0 Answers  

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

What is the maximum length of sqlca?

0 Answers  

what types of copies can be made with the COPY Utility ?

1 Answers  

What is plan in cobol db2?

0 Answers  

What is the picture clause of the null indicator variable?

6 Answers  

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

What is copy book?

1 Answers   Thomson Reuters,

what is the use of cursors?

3 Answers   iGate,

For more DB2 Interview Questions Click Here
Categories