【OCP 12c】OCP 062最新考试题库原题解析-第16题

文章来源：更新时间:2019/4/18 14:53:58

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

2018年OCP 11g考试原题解析已经讲解30多次课，500多道考试原题，最终达到98%以上的考题覆盖度及95%以上的考试通过率。

2019年OCP 11g将升级到12c，OCP 12c考试解析免费公开课也已经开始了，欢迎大家收看!

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：1015267481 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与

-------------------------------------------------------

QUESTION 16

Examine the structure of the sales table, which is stored in a locally managed tablespace with

Automatic Segment Space Management (ASSM) enabled.

Name Null? Type

-------------------------------------------- ------------------------------------- -----------------------------

PROD_ID NOT NULL NUMBER

CUST_ID NOT NULL NUMBER

TIME_ID NOT NULL DATE

CHANNEL_ID NOT NULL NUMBER

PROMO_ID NOT NULL NUMBER

QUANTITY___SOLD NOT NULL NUMBER (10, 2)

AMOUNT SOLD NOT NULL NUMBER (10, 2)

You want to perform online segment shrink to reclaim fragmented free space below t he high water mark.

A. Row movement is enabled.

B. Referential integrity constraints for t he table are disabled.

C. No queries are running on this table.

D. Extra disk space equivalent to the size of t he segment is available in t he tablespace.

E. No pending transaction exists on t he table.

Correct Answer: A