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

The correct answer is A. They are generated if STATISTICS_LEVEL is set to TYPICAL. B. They are generated if STATISTICS_LEVEL is set to ALL. E. They can be retained forever. A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR…

Monitoring and Tuning

Question

Options

AThey are generated if STATISTICS_LEVEL is set to TYPICAL.
BThey are generated if STATISTICS_LEVEL is set to ALL.
CThey are always created automatically.
DThey are always created manually.
EThey can be retained forever.
FThey are generated if STATISTICS_LEVEL is set to BASIC.

How the community answered

(41 responses)

A
76% (31)
C
2% (1)
D
15% (6)
F
7% (3)

Explanation

A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR Warehouse, allowing these reports to be kept, and queried, F - FALSE. STATISTICS_LEVEL=BASIC stops them being generated Ref: https://docs.oracle.com/en/database/oracle/oracle- database/19/refrn/STATISTICS_LEVEL.html

Topics

#AWR snapshots#STATISTICS_LEVEL#snapshot retention#automatic workload repository

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice