Oracle Database Administration II — Question 70

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

Answer options

• A. By default, AWR snapshots are taken every 60 minutes.
• B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
• C. By default, AWR snapshots are retained for 7 days.
• D. The taking of AWR snapshots can be disabled.
• E. AWR data is stored in the SYSTEM tablespace.

Correct answer: A, B, D

Explanation

The correct answers are A, B, and D because AWR snapshots are indeed taken every 60 minutes by default, the collection level is influenced by the STATISTICS_LEVEL parameter, and snapshots can be disabled. Option C is incorrect as AWR snapshots are retained for 8 days by default, and option E is wrong because AWR data is actually stored in the SYSAUX tablespace, not the SYSTEM tablespace.