Question 156:
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: - Long-running queries are not affected. - No extra space is used. - Data manipulation language (DML) operations on the table succeed at all times throughout the process. - Unused space is reclaimed both above and below the high water mark. Which ALTER TABLE option would you recommend?
Answer options:
A. DEALLOCATE UNUSED B. SHRINK SPACE CASCADE C. SHRINK SPACE COMPACT D. ROW STORE COMPRESS BASIC