Exam 1z0-083 topic 1 question 147 discussion

ABE correct 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).

a little tricky: AWR data IS stored in SYSAUX, but it is stored on a per-container/PDB basis.

https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-performance-diagnostics.html#GUID-B4B0899D-90A3-4E19-8654-1D5C34A48FD5

I would go with ABE. It is confusing, however. AWR reports can run in pluggables; therefore, I assume C is incorrect because AWR reports cannot run in pdb$seed - which would (by extension) make A incorrect as well. SQL> alter pluggable database close; SQL> alter pluggable database open; SQL> show con_name CON_NAME ------------------------------ PDB$SEED SQL> EXEC dbms_workload_repository.create_snapshot() BEGIN dbms_workload_repository.create_snapshot(); END; * ERROR at line 1: ORA-13518: Invalid database id (0) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 145 ORA-06512: at line 1

useful query select * from v$sysaux_occupants;

but F is correct as well, the SYSAUX tablespace has another schemas data apart from AWR F. No AWR data is stored in the CDB$ROOT SYSAUX tablespaspce

A and B are correct no doubt, E is also correct: SQL> show con_name CON_NAME ------------------------------ PDB1 SQL> EXECUTE dbms_workload_repository.create_snapshot(); PL/SQL procedure successfully completed.