Oracle Database Administration II — Question 129

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
(Choose three.)

Answer options

• A. ADDM can run in a nonroot container.
• B. AWR snapshots can be created in CDB$ROOT.
• C. AWR reports can be generated while connected to any container.
• D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• E. AWR snapshots can be created in a PDB.
• F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Correct answer: C, E, F

Explanation

The correct answers are C, E, and F. AWR reports can indeed be generated while connected to any container, and AWR snapshots can be created in a Pluggable Database (PDB). Additionally, no AWR data is stored in the CDB$ROOT SYSAUX tablespace, as AWR data is specific to PDBs. The other options are incorrect because AWR snapshots cannot be created in CDB$ROOT, and all AWR data is not stored in that tablespace.