移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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 the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()

发布日期:2020-04-10

A senior DBA asked you to execute the following co...
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 the SUBSCRIBE_LOG table are rarely accessed.

E

All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题