Oracle Database 12c: Advanced Administration — Question 1

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 the process. iv.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

Correct answer: A

Explanation

The correct answer is A, DEALLOCATE UNUSED, as it specifically targets the reclamation of unused space without affecting dependent objects or DML operations. Options B and C involve shrinking the space, which may not guarantee that DML operations will succeed throughout the process. Option D, ROW STORE COMPRESS BASIC, does not address the fragmentation issue or reclaim unused space effectively.