Oracle Database Administration II — Question 107

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

Answer options

• A. They are generated if STATISTICS_LEVEL is set to TYPICAL.
• B. They are generated if STATISTICS_LEVEL is set to ALL.
• C. They are always created automatically.
• D. They are always created manually.
• E. They can be retained forever.
• F. They are generated if STATISTICS_LEVEL is set to BASIC.

Correct answer: A, B, E

Explanation

Options A and B are correct because AWR snapshots are generated when the STATISTICS_LEVEL is set to TYPICAL or ALL. Option E is also correct as AWR snapshots can be retained for an indefinite period if configured properly. Options C and D are incorrect because AWR snapshots are automatically created under certain conditions, not manually, and they do not always have to be created. Option F is wrong since AWR snapshots are not generated when STATISTICS_LEVEL is set to BASIC.