Examine these commands, which execute successfully:
Which statement is true?
A.
AD DM 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.
The Answer Is:
D
This question includes an explanation.
Explanation:
The DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS procedure allows setting attributes related to AWR snapshots. While the interval setting controls the frequency of snapshot generation, purging them is a separate process that can be managed either automatically (with retention settings) or manually.References:
Oracle Database PL/SQL Packages and Types Reference, 19c
Oracle Multitenant Administrator’s Guide, 19c
1z0-084 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"