When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?
A. INCLUDING DEPENDENCIES
B. INCLUDING DEPENDENCIES CASCADE
C. COMPACT
D. CASCADE
E. None of the above
The Segment Shrink SHRINK SPACE command specifying the table name,and then includeing the CASCADE clause,will reclaim space from the table segment and all dependent index segments,as reported by the DBMS_SPACE.OBJECT_DEPENDENT_SEGMENT function.