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
Which clause should you use?
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?
D is correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm
The CASCADE clause extends the segment shrink operation to all dependent segments of the object. For example, if you specify CASCADE when shrinking a table segment, all indexes of the table will also be shrunk. (You need not specify CASCADE to shrink the partitions of a partitioned table.) To see a list of dependent segments of a given object, you can run the OBJECT_DEPENDENT_SEGMENTS procedure of the DBMS_SPACE package.