How many clustering indexes can be defined for a table?

Answer Posted / s

Only one clustering index can be defined.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database reorganization?

583


What is table space in db2?

571


What is scrollable cursor in db2?

574


Which isolation level provides maximum concurrency?

653


What is the role of the data page in the db2 database?

581






What is difference between isnull and coalesce?

607


What is reorg and runstats in db2?

683


How do I delete a table in database?

593


What are the various isolation levels possible?

638


What is an instance database?

590


Define db2 and its databases?

613


Where do you specify them?

672


What is dbrm? When it will be created?

589


Mention the different locking levels that are available in db2.

634


Mention some fields that are a part of sqlca.

591