当前位置:首页 > 英语题型 > 正文内容

646.View the exhibit and examine the TRANS table's storage infor

2023-12-01英语题型

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

正确答案是B

扫描二维码免费使用微信小程序搜题/刷题/查看解析。

版权声明:本文由翰林刷题小程序授权发布,如需转载请注明出处。

本文链接:https://20230611.cn/post/5307335.html