多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • 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
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题