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?
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.
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA
A,C,D.
https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN11600
19.3.2.1 About the Segment Advisor
The Segment Advisor generates the following types of advice:
1. If the Segment Advisor determines that an object has a significant amount of free space, it recommends online segment shrink. If the object is a table that is not eligible for shrinking, as in the case of a table in a tablespace without automatic segment space management, the Segment Advisor recommends online table redefinition.
2. If the Segment Advisor determines that a table could benefit from compression with the advanced row compression method, it makes a recommendation to that effect. (Automatic Segment Advisor only. See “Automatic Segment Advisor”.)
3. If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows.
Not C
In 12 c the default space assigment for “locally managed tablespaces” is ” automatic space management” so the answer is not true
locally managed tablespaces(start from 9i for user tbs) and ASSM from 9i.
C true