Oracle
1Z0-063 · Question #3
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:
The correct answer is A. DEALLOCATE UNUSED. See the full explanation below for the reasoning.
Question
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:
Options
- ADEALLOCATE UNUSED
- BSHRINK SPACE CASCADE
- CSHRINK SPACE COMPACT
- DROW STORE COMPRESS BASIC
- ILong-running queries are not affected.
How the community answered
(43 responses)- A84% (36)
- B9% (4)
- C5% (2)
- D2% (1)
Community Discussion
No community discussion yet for this question.