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:
C