Q20. Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
- A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
- B. AWR snapshots can be created in a PDB.
- C. AWR snapshots can be created in CDB$ROOT.
- D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
- E. ADDM can run in a nonroot container.
- F. AWR reports can be generated while connected to any container.
Answer: BCE
The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root.
The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB.
Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with Oracle Database 19c, you can also use ADDM in a pluggable database (PDB).