I think it's C and E. It requires 2 snapshots if addm is run manually, true. But it says in document "ADDM analysis results that are automatically created each time an AWR snapshot is taken." which seems means even one AWR snapshot is enough for he automatic ADDM run.
Option D is partially correct, ADDM does get generaed automatically
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-performance-diagnostics.html#GUID-AEE549F3-DDF9-4977-8A0A-FE1E47C75679
ADDM can analyze any two AWR snapshots (on the same database), as long as ...
The data in the snapshot interval is analyzed by ADDM. ADDM compares the differences between snapshots to determine which SQL statements to capture, based on the effect on the system load. The ADDM analysis shows the number of SQL statements that need to be captured over time. ref: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025
Answer: CD
Answer: CE
An ADDM analysis is performed after each AWR snapshot (every hour by default), and the results are saved in the database.
ref: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT301
https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025
In above page there is a a sentence below, which indicates at least 2 AWR snapshoot must be present to run "addmrpt.sql" for ADDM. So D is correct E is incorrect.
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
cweather328
Highly Voted 4 years, 9 months agokhan
Highly Voted 5 years, 8 months agoRay520
Most Recent 2 years, 7 months agojackymak
2 years, 9 months agoOracle2020
3 years, 4 months agocrucinal1
3 years, 6 months agobadguy001djh
3 years, 8 months agoModasser
3 years, 11 months agoModasser
3 years, 10 months agoTuxBingo
4 years, 4 months agokanth
4 years, 10 months agordnkrkmz
5 years, 10 months ago