Oracle
1Z0-062 · Question #30
1Z0-062 Question #30: Real Exam Question with Answer & Explanation
The correct answer is B: The AWR data is stored in memory and in the database.. AWR stores snapshot data both in memory and in the SYSAUX tablespace, drives self-tuning components, and computes time model statistics - but does not own its tables under SYSTEM and does not manage tracing or logging.
Question
Which three statements are true about Automatic Workload Repository (AWR)?
Options
- AAll AWR tables belong to the SYSTEM schema.
- BThe AWR data is stored in memory and in the database.
- CThe snapshots collected by AWR are used by the self-tuning components in the database
- DAWR computes time model statistics based on time usage for activities, which are displayed in
- EAWR contains system wide tracing and logging information.
Explanation
AWR stores snapshot data both in memory and in the SYSAUX tablespace, drives self-tuning components, and computes time model statistics - but does not own its tables under SYSTEM and does not manage tracing or logging.
Common mistakes.
- A. AWR tables are owned by SYS and stored in the SYSAUX tablespace, not in the SYSTEM schema.
- E. System-wide tracing and logging is handled by the Automatic Diagnostic Repository (ADR) via alert logs and trace files, which is a separate subsystem from AWR.
Concept tested. Oracle AWR architecture, storage, and self-tuning integration
Community Discussion
No community discussion yet for this question.