ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

156 / 190

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