Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
A.
ADDM can recommend shrinking the buffer cache.
B.
ADDM can recommend extending the buffer cache.
C.
By default, MMON creates an AWR snapshot every 30 minutes.
D.
ADDM performs its analysis only when a DBA requests it.
E.
By default, AWR snapshots are automatically purged after eight days.
F.
AWR snapshots must be deleted when no longer required by ADDM.
AWR Snapshot's default interval is 1 hour and retention is 8 days. It means All AWR statistics are collected every 1 hour and they are kept 8 days by default.
That means E is correct and F is wrong… so final correct answers are A; B; E
AWR (Automatic Workload Repository) snapshots cannot be created directly in the CDB$ROOT container in Oracle Database. AWR is a feature of Oracle Database that collects and stores performance statistics for diagnosing performance issues.
B is a wrong answer
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ald85
Highly Voted 3 years, 7 months agoama
3 years agojanw
Highly Voted 3 years, 5 months agoGuhborges
Most Recent 6 months, 3 weeks agoDhanushbh
7 months, 3 weeks agoScottL
9 months, 1 week ago_gio_
9 months, 2 weeks agoYennism
1 year, 2 months agoflaviogcmelo
1 year, 4 months agorashedptdba
2 years, 4 months agoNeil107
2 years, 5 months agoundoundo
3 years, 2 months agoundoundo
3 years, 2 months agocerebro2000x
3 years, 6 months agotaotsumiau
3 years, 7 months ago