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

How do you check for a null value in a db2 column?

2 Answers  


How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,


What is a clustering index ?

3 Answers  


What are db2 objects?

0 Answers  


Can you search give an array in the WHERE clause of a db2 query?

1 Answers  


What is the size of a data page?

2 Answers   IBM,


1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


What is meant by AUTO COMMIT?

3 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


Categories