You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?

Online table redefinition via DBMS_REDEFINITION reorganizes a table online to compact space and is supported in dictionary-managed tablespaces; the Segment Advisor will recommend it when reclaimable space is identified in such tablespaces.

Segment shrink (ALTER TABLE SHRINK SPACE) requires Automatic Segment Space Management because it relies on ASSM bitmap blocks to compact rows below the high water mark; dictionary-managed tablespaces use freelists and do not support this operation.

The Segment Advisor also recommends online table redefinition for tables residing in locally managed tablespaces when significant wasted space or high water mark issues are detected, making redefinition a valid advisory outcome for both tablespace types.

The Segment Advisor samples block-level statistics and checks for row migration and chaining by analyzing the CHAINED_ROWS diagnostic; when chained rows exceed a threshold it explicitly advises corrective actions such as table move or redefinition.

Freelist-managed tables use a linked list of blocks for free space tracking rather than ASSM bitmaps, which makes the SHRINK SPACE mechanism incompatible; the Segment Advisor cannot recommend segment shrink for any freelist-managed segment.