Oracle
1Z0-062 · Question #199
1Z0-062 Question #199: Real Exam Question with Answer & Explanation
The correct answer is C: SHRINK SPACE COMPACT. SHRINK SPACE COMPACT compacts fragmented rows in the SALES table without resetting the high water mark, touching dependent objects, or blocking concurrent queries.
Question
You want to reduce fragmentation and reclaim unused space of the SALES table but not its dependent objects. During the operation, you want to ensure the following:
Options
- ADEALLOCATE UNUSED
- BSHRINK SPACE CASCADE
- CSHRINK SPACE COMPACT
- DROW STORE COMPRESS BASIC
- ILong-running queries are not affected
Explanation
SHRINK SPACE COMPACT compacts fragmented rows in the SALES table without resetting the high water mark, touching dependent objects, or blocking concurrent queries.
Common mistakes.
- A. DEALLOCATE UNUSED releases space above the high water mark but does not compact fragmented rows or reclaim space scattered within the allocated segment extents.
- B. SHRINK SPACE CASCADE compacts the table and then propagates the shrink operation to all dependent objects including indexes, which violates the requirement to leave dependent objects untouched.
- D. ROW STORE COMPRESS BASIC applies table compression to reduce storage for future bulk inserts, but does not address fragmentation or reclaim currently unused space within the segment.
Concept tested. Oracle online segment shrink compact phase without cascade
Community Discussion
No community discussion yet for this question.