Which two statements are true about space–saving features in an Oracle Database?
A.An index created with the UNUSABLE attribute has no segment.
B.Private Temporary Tables(PTTs) store metadata in memory only.
C.Private Temporary Tables(PTTs) when used, are always dropped at the next commit statement.
D.An index that is altered to be UNUSABLE will retain its segment
E. A table that is truncated will always have all of its extents removed
解析：实际上PTT有两种：Transaction–specific (ON COMMIT DROP DEFINITION)和session–specific (ON COMMIT PRESERVE DEFINITION)。这两种在commit时都会删除表中的数据，但第二种是不会删除表定义的，因此C是错的。
SQL> create index in_1 on table_1(no) unusable;
Index created.
SQL> select segment_name,blocks from user_segments where segment_name in ('IN_1');
no rows selected
SQL> alter index in_1 rebuild;
Index altered.
SQL> select segment_name,blocks from user_segments where segment_name in ('IN_1');
SEGMENT_NAME BLOCKS
-------------------- ----------
IN_1 8
发现创建索引时为unusable是不创建段的，只有重建索引才会有段。所以A正确。
经过测试，truncate table初始的extent不会删除。所以E错误。
经过测试，alter index in_a unusable，会删除所有的segment。所以D错误。
原文地址:https://blog.csdn.net/richard2t/article/details/134591999
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如若转载，请注明出处：http://www.7code.cn/show_7757.html
如若内容造成侵权/违法违规/事实不符，请联系代码007邮箱：suwngjj01@126.com进行投诉反馈，一经查实，立即删除！
