Which three statements are true concerning the Automati…

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

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”

Explanation:
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.
https://docs.oracle.com/cloud/latest/db112/REFRN/initparams018.htm#REFRN10325
http://www.oracle-class.com/?p=2409