Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.
All AWR tables belong to the SYSTEM schema
B.
The AWR contains systemwide tracing and logging information
C.
The snapshots collected by the AWR are accessible through data dictionary views
D.
The snapshots collected by the AWR are used by self-tuning components in the database
a and b are correct
AWR data are stored in sysaux
AWR is stored in SYSTEM tablespace but are owned by SYS user not SYSTEM.
B,C
(AWR) Automatic workload repository is a collection of persistent system performance statistics owned by SYS.
It resides in SYSAUX tablespace.
Option C is correct:
select snap_id from DBA_HIST_SNAPSHOT