第88题-OCP认证062考试题库2019最新考题解析

文章来源：更新时间:2019/7/3 9:05:50

在线老师点击咨询：

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

我要咨询

2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，

2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新

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

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

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

QUESTION 88

A senior DBA asked you to execute the following command to improve performance:

SQL> ALTER TABLE subscribe_log STORAGE (BUFFER_POOL recycle);

You checked the data in t he SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

What could be a reason for this recommendation?

A. The keep pool is not configured.

B. Automatic Workarea Management is not configured.

C. Automatic Shared Memory Management is not enabled.

D. The data blocks in t he SUBSCRIBE_LOG table are rarely accessed.

E. All the queries on t he SUBSCRIBE_LOG table are rewritten to a materialized view.

Correct Answer: D

Section: (none)

Explanation：recycle 池就是存放大表，而且很少访问的数据