In oracle 10g, which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?

  1. The analysis tool doesn’t provide output for the performance of SQL statement

  2. The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.

  3. The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.

  4. The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.


Correct Option: D

Find more quizzes: