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

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

What is a plan and package in db2?

0 Answers  

what is load and unload in db2

1 Answers   IBM,

How to access db2 tables in mainframe?

0 Answers  

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

How does db2 sample database connect?

0 Answers  

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

What are common abends

1 Answers   SPIC, Virtusa,

What is netezza database?

0 Answers  

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

What is the difference between cursor and select statement?

0 Answers  

For more DB2 Interview Questions Click Here
Categories