Multiple choice technology databases

In which tablespace AWR data is stored

  1. SYSTEM

  2. USERS

  3. SYSAUX

  4. INDEX

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

AWR (Automatic Workload Repository) data is stored in the SYSAUX tablespace in Oracle 10g and later. SYSAUX was introduced specifically to relieve the SYSTEM tablespace of auxiliary data like AWR statistics, making option C correct. SYSTEM is for core dictionary data, USERS for user objects.