Oracle 1z0-182 Question Answer
Which two are true about shrinking a segment online?
To shrink a table it must have row movement enabled.
It is not possible to shrink either indexes or Index Organized Tables (IOTs).
To shrink a table it must have a UNIQUE KEY constraint.
It must be in a tablespace that uses Automatic Segment Space Management (ASSM).
To shrink a table it must have a PRIMARY KEY constraint.
A.True. ROW MOVEMENT must be enabled for SHRINK SPACE.
B.False. Indexes and IOTs can be shrunk with CASCADE.
C.False. No such constraint requirement.
D.True. ASSM is required for online shrinking.
E.False. No primary key requirement.
TESTED 16 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved