433.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
Answer: D
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/13431595
使用SHRINK SPACE子句可以收缩段中的空间。如果指定了CASCADE,则收缩行为将级联到所有支持收缩操作的从属段,但实体化视图、LOB 索引和IOT(索引表)映射表例外。
CASCADE If you specify CASCADE
, then Oracle Database performs the same operations on all dependent
objects of table
, including secondary indexes on index-organized tables.