OCP-1Z0-053-V12.02-433题

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.