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?

For tables in dictionary-managed tablespaces, segment shrink is unavailable because that operation requires bitmap-based free space tracking found only in ASSM. As an alternative, the Segment Advisor may recommend online table redefinition using DBMS_REDEFINITION, which can reclaim space in any tablespace type.

Segment shrink requires Automatic Segment Space Management in a locally managed tablespace - it cannot be used for tables in dictionary-managed tablespaces, regardless of any additional conditions appended to the statement.

Online table redefinition is also a valid Segment Advisor recommendation for tables in locally managed tablespaces, especially when the segment cannot be shrunk due to freelist management or other constraints. DBMS_REDEFINITION rebuilds the table online without downtime, reclaiming fragmented space in the process.

The Segment Advisor performs physical row analysis and detects chained rows - rows whose size exceeds a block's available space and span multiple blocks. It reports chained rows as an advisory finding because they degrade I/O performance and indicate a need for table reorganization or a block size adjustment.

Segment shrink is not supported for freelist-managed tables because the high water mark reclamation process depends on ASSM bitmap space tracking, which freelist-managed segments do not have.