PrepAway - Latest Free Exam Questions & Answers

Which steps should be performed at a minimum to make it a partitioned-by-range table space?

Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a
minimum to make it a partitioned-by-range table space?

PrepAway - Latest Free Exam Questions & Answers

A.
Issue ALTER TABLESPACE with a valid SEGSIZE > 0

B.
Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE
> 0

C.
Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing
table definition, then issue ALTER
TABLESPACE with a valid SEGSIZE > 0

D.
Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing
table definition, create a partitioned index and
issue ALTER TABLESPACE with a valid SEGSIZE > 0

Explanation:


Leave a Reply