how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none

Answer Posted / nawal kishore

Partitions can be range from 1 to 4096

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does db2 sample database connect?

563


What is the difference between drop table and delete table?

543


What is a db2 table?

593


Explain how can you do the explain of a dynamic sql statement?

647


Explain correlated sub-queries.

583






What is a buffer in memory?

589


can all users have the privilage to use the sql statement select * (dml)?

634


Comment whether the cursor is closed during commit or not.

662


Explain db2.

607


What is copy pending status in db2?

630


What is an instance database?

594


Are view updateable?

625


What is runstats db2?

576


Why do we need reorg in db2?

555


What is the use of dclgen in db2?

586