Oracle Database Administration 2022 Certified Professional — Question 38

Examine these commands, which execute successfully:
SQL> ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE;
SQL> EXEC dbms_workload_repository.modify_snapshot_settings(interval=>60);
Which statement is true?

Answer options

• A. ADDM is enabled for all pluggable databases.
• B. ADDM, AWR, and ASH reports can be purged automatically.
• C. AWR snapshots in all pluggable databases will be purged automatically after every 60 mins.
• D. AWR snapshots can be purged manually in pluggable databases.

Correct answer: A

Explanation

The correct answer is A because enabling AWR_PDB_AUTOFLUSH_ENABLED allows the Automatic Database Diagnostic Monitor (ADDM) to operate for all pluggable databases. Option B is incorrect as the statement does not directly relate to report purging. Option C misinterprets the command functionality and D is irrelevant since the question specifically addresses the automatic purging feature.