oracle每日一题0924

Which three are true about Automatic Workload Repository (AWR) snapshots?
A. They can be retained forever.
B. They are always created automatically.
C. They are always created manually.
D. They are generated if STATISTICS LEVEL is set to TYPICAL.
E. They are generated if STATISTICS LEVEL is set to BASIC.
F. They are generated if STATISTICS LEVEL is set to ALL.

个人认为正确答案为ADF
在DEF三个选项中，当且仅当LEVEL设置为BASIC时，数据库会停止收集AWR报告。
（原文：Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:Automatic Workload Repository (AWR) Snapshots）
（https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/STATISTICS_LEVEL.html#GUID-16B23F95-8644-407A-A6C8-E85CADFA61FF）

因此排除E选项。

关于BC选项，AWR报告可以手动生成也可以自动生成，手动生成AWR报告大多数时候没有必要，除非你想获得比快照间隔更短的时间段内比较性能数据时，手动生成报告更为优秀。（原文：Manually creating snapshots is usually not necessary because AWR generates snapshots of the performance data once every hour by default. In some cases, however, it may be necessary to manually create snapshots to capture different durations of activity, such as when you want to compare performance data over a shorter period than the snapshot interval.）（https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025）。

这道题的问题在这个always上，所以与其说这是一道OCP题，它更像你的初中英语题。我查了一下always的英语解释:
always：all the time.
例句：“the sun always rises in the east”.
(Definitions from Oxford Languages)

AWR可以手动生成也可以自动生成。而太阳只会从东边升起。所以，在这里用always是不合适的。排除BC。

A选项，同样是一道英语题。can 的同义词 be able to。有能力，可以的意思。AWR默认每小时生成一份，保留八天，但是我们可以通过更改snapshot retention和snapshot interval（minutes）这两个参数来改变保留时间和生成间隔的策略。所以如果我们在retention里填999999999999999999999999999999999999999999999999999999.那么我们其实就可以把它视为forever。

综上，个人认为答案为ADF