Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
B. AWR data is stored in memory and in a database.
C. All AWR tables belong to the SYSTEM schema.
D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
E. An AWR snapshot contains system-wide tracing and logging information.
|
Download Printable PDF. VALID exam to help you PASS. |
 |