"一个高级的DBA要求您执行以下命令以提高性能： SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); 您检查了SUBSCRIBE_LOG表中的数据，发现它是一个包含一百万行的大型表。提出此建议的原因可能是什么？"
A
未启用自动共享内存管理。
B
保持池未配置。
C
未配置自动工作区管理。
D
SUBSCRIBE_LOG表中的数据块很少被访问。
E
SUBSCRIBE_LOG表上的所有查询都重写为实例化视图。
选择d
原题：
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.
Answer: D
评论
有用 1
