Oracle Database 12c: Installation and Administration — Question 191

Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

Answer options

• A. segments in tablespaces that have exceeded a critical or warning space threshold
• B. segments that have the highest growth rate in a database
• C. segments that are sparsely populated and have more than 10% of free space below the high water mark.
• D. segments that have unusable indexes
• E. segments for tables created using ADVANCED ROW COMPRESSION

Correct answer: A, B

Explanation

The correct answers are A and B because the Automatic Segment Advisor focuses on segments that either exceed critical space thresholds or exhibit the highest growth rates, indicating potential areas for optimization. Options C, D, and E do not align with the primary focus of the advisor, which is on space management and growth, not merely sparsity, index usability, or specific compression methods.