Oracle Database 11g: Administration I — Question 3

Which two are true about AWR snapshots? (Choose two.)

Answer options

• A. They are always created automatically.
• B. They can be modified by using DMLs.
• C. They are not generated if STATISTICS_LEVEL is set to TYPICAL.
• D. They are stored in the SYSAUX tablespace.
• E. They can be retained forever.

Correct answer: A, B

Explanation

Option A is correct because AWR snapshots are indeed created automatically at specified intervals. Option B is also correct as snapshots can be modified with DML commands. Options C, D, and E are incorrect: C is wrong because AWR snapshots are generated even with STATISTICS_LEVEL set to TYPICAL, D is false since they are stored in the AWR tablespace, and E is incorrect as snapshots have a retention period.