646.View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
Answer: B
使用SHRINK SPACE可以收缩段中的空间。
如果指定了CASCADE，则收缩行为将级联到所有支持收缩操作的从属段，但MV、LOB索引和IOT映射表除外。
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
Answer: B
使用SHRINK SPACE可以收缩段中的空间。
如果指定了CASCADE，则收缩行为将级联到所有支持收缩操作的从属段，但MV、LOB索引和IOT映射表除外。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2120589/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q636
下一篇：
1Z0-053 V13.02 Q651
请登录后发表评论
登录
全部评论
