Oracle OCP 19c认证考试1Z0-082题库最新解析 第十九题
source link: https://studygolang.com/articles/36448
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Oracle OCP 19c认证考试1Z0-082题库最新解析 第十九题
19975296942 · 大约23小时之前 · 25 次点击 · 预计阅读时间 1 分钟 · 大约8小时之前 开始浏览考试科目：1Z0-082
考试题量：90
通过分数：60%
考试时间：150min
原文链接:【云贝教育】Oracle 19c OCP 082题库解析(19) - 课程体系 - 云贝教育 (yunbee.net)
本文为云贝教育郭一军（微信：guoyJoe）原创，请尊重知识产权，转发请注明出处，不接受任何抄袭、演绎和未经注明出处的转载
19. Which three statements are true about Deferred Segment Creation in Oracle databases?
A.It is the default behavior for tables and indexes.
B.It is supported for sys-owned tables contained in locally managed tablespaces
C.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
D.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table
E.It is supported for Index Organized Tables(IOTs) contained in locally managed tablespaces.
参考答案：ACD
延迟段创建不支持的表类型包括：索引组织表
用户SYS、SYSTEM、PUBLIC、OUTLN和XDB下的表不支持延迟段创建。
SELECT p.ISSES_MODIFIABLE FROM V$PARAMETER P WHERE P.NAME = 'deferred_segment_creation'
ISSES_MODIFIABLE
1 TRUE
--测试
alter session set deferred_segment_creation=true;
alter session set deferred_segment_creation=false;
有疑问加站长微信联系（非本文作者）
入群交流（和以上内容无关）：加入Go大咖交流群，或添加微信：liuxiaoyan-s 备注：入群；或加QQ群：692541889
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK