第88題-OCP認證062考試題庫2019最新考題解析
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢2018年的時候,OCP 11g考試題庫大更新,052 053出現了很多新題,
2019年,11g即將停考的前期,Oracle又出現了一次大變動,12c出現了很多新題,比如062 063題庫大更新
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:http://ke.qq.com/course/326223
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 池就是存放大表,而且很少訪問的數據