Q139 Which two are true about shrinking a segment online? (Choose two.)
- (A). It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- (B). It always eliminates all migrated rows if any exist in the table
- (C). To shrink a table it must have a PRIMARY KEY constraint
- (D). To shrink a table it must have a UNIQUE KEY constraint
- (E). To shrink a table it must have row movement enabled
- (F). It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
Answer: E,F