Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment? 

Answer options:

A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to "none"

ADE

AWR snapshots are collect at database level. Oracle extends the AWR tool for RAC databases by adding the possibility to generate snapshots reports against the whole cluster database, some database instances of the cluster database, a specific database instance of the cluster database, statistics for a specific select query. D: AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the AWR snapshot start time. AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time. Incorrect Answers: E: CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available: ✑ The DIAGNOSTIC pack includes AWR, ADDM, and so on. ✑ The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on. The NONE value means that both packs are not available. References: https://docs.oracle.com/cloud/latest/db112/REFRN/initparams018.htm#REFRN10325 http://www.oracle-class.com/?p=2409