For which of the following can you use Segment Shrink? (Choose all that apply.)
A.
Heap tables
B.
Tables with function-based indexes
C.
Indexes
D.
Partitions and subpartitions
E.
None of the above
For which of the following can you use Segment Shrink? (Choose all that apply.)
For which of the following can you use Segment Shrink? (Choose all that apply.)
A.
Heap tables
B.
Tables with function-based indexes
C.
Indexes
D.
Partitions and subpartitions
E.
None of the above
A,C and D are correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm
Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM). Within an ASSM tablespace, all segment types are eligible for online segment shrink except these:
-IOT mapping tables
-Tables with rowid based materialized views
-Tables with function-based indexes
-SECUREFILE LOBs
You can shrink space in a table, index-organized table, index, partition, subpartition, materialized view, or materialized view log. You do this using ALTER TABLE, ALTER INDEX, ALTER MATERIALIZED VIEW, or ALTER MATERIALIZED VIEW LOG statement with the SHRINK SPACE clause.
C would actually be correct if it were an Index Organized Table.
Is is also correct for an index. 🙂