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

How many clustering indexes can be defined for a table?

Question Posted / guest

Answers were Sorted based on User's Feedback



How many clustering indexes can be defined for a table?..

Answer / s

Only one clustering index can be defined.

Is This Answer Correct ?    11 Yes 0 No

How many clustering indexes can be defined for a table?..

Answer / mehdee

Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

What are the benefits of using the db2 database?

0 Answers  

What is a DB2 plan?

8 Answers  

How do I delete a table in database?

0 Answers  

What is DCLGEN ?

2 Answers  

is it compulsory commitment control in journal?

0 Answers   TCS,

what is sql abend code -801,-802?

2 Answers  

what is the difference between join and union?

4 Answers   IBM,

how can we find nth max salary from A table

5 Answers   IBM,

Mention the downsides of page level lock.

0 Answers  

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

What is the reason behind not using select * in embedded sql programs?

0 Answers  

For more DB2 Interview Questions Click Here
Categories