Which three statements are true about Automatic Workload Repository (AWR)?
A.
AWR contains system wide tracing and logging information.
B.
AWR computes time model statistics based on time usage for activities, which are
displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
C.
All AWR tables belong to the SYSTEM schema.
D.
The snapshots collected by AWR are used by the self-tuning components in the
database
E.
The AWR data is stored in memory and in the database.
B,D,E
Correct B,D,E
https://docs.oracle.com/database/121/TGDBA/gather_stats.htm#TGDBA167
Automatic Workload Repository
AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This gathered data is stored both in memory and in the database, and is displayed in both reports and views.
b d e
B D E