Oracle Database 12c: Installation and Administration — Question 216

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? (Choose three.)

Answer options

• A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C. It may advise the use of online table redefinition for tables in locally managed tablespaces
• D. It will detect and advise about chained rows.
• E. It may advise the use of segment shrink for free list managed tables.

Correct answer: A, C, D

Explanation

The correct answers A, C, and D relate to the capabilities of the segment advisor in advising on online table redefinitions and detecting chained rows. Option B is incorrect because segment shrink cannot be advised for tables in dictionary managed tablespaces with chained rows. Option E is also wrong as segment shrink is not typically advised for free list managed tables.