A. All metrics are instance related.

B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

C. A space usage management alert is automatically cleared after the underlying problem is resolved.

D. They are generated by SMON when a tablespace is 97% full.

E. Metrics are statistical counts for a specific unit.

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

A. All metrics are instance related.

B. They are generated by SMON when a tablespace is 97% full.

C. STATISTICS_LEVEL must be set to ALL to generate alerts.

D. A space usage management alert is automatically cleared after the underlying problem is resolved.

E. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

F. Metrics are statistical counts for a specific unit.

A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

C. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

D. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

E. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

C. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

A. 1, 2, 3, 4, 5, 7, 8

B. 1, 2, 3, 4, 5, 6, 7, 8

C. 1, 2, 4, 5, 7, 8

D. 2, 4, 5, 6, 7

E. 1, 2, 4, 6, 7, 8