Which alter TABLE option would you recommend?

You want to reduce fragmentation and reclaim unused space for the sales table but not its
dependent objects. During this operation, you want to ensure the following: i.Long-running
queries are not affected. ii.No extra space is used. iii.Data manipulation language (DML)
operations on the table succeed at all times throughout theprocess. iv.Unused space is
reclaimed both above and below the high water mark. Which alter TABLE option would you
recommend?

You want to reduce fragmentation and reclaim unused space for the sales table but not its
dependent objects. During this operation, you want to ensure the following: i.Long-running
queries are not affected. ii.No extra space is used. iii.Data manipulation language (DML)
operations on the table succeed at all times throughout theprocess. iv.Unused space is
reclaimed both above and below the high water mark. Which alter TABLE option would you
recommend?

A.
DEALLOCATE UNUSED

B.
ROW STORE COMPRESS BASIC

C.
SHRINK SPACE COMPACT

D.
SHRINK SPACE CASCADE

Explanation:

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

lukasz

lukasz

C

Reply

lukasz

lukasz

changed my mind, it ll be A since compact option wont deallocate space

Reply

Tom

Tom

C is a good answer.

Reply

yogui

yogui

C
The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed.

Reply