Which two are true about shrinking a segment online? (Choose two.) By Singh | January 1, 2023 0 Comment 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) Correct Answer: C,E Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm