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...


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



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,


Categories