hiexam
oracle · 1z0-067 · Q605 · multiple_choice · topic_1

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During thi…

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?
  • A.DEALLOCATE UNUSED
  • B.SHRINK SPACE CASCADE
  • C.SHRINK SPACE COMPACT
  • D.ROW STORE COMPRESS BASIC
Explanation
correct answer is C

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.