A.V$SESSION_WAIT _CLASS displays waits broken down by wait class only for waiting sessions.

B.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

C.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

D.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

E.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

F.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

A.Reduced physical I/O

B.Improved Serial Execution performance

C.Reduced virtual memory utilization

D.Reduced logical I/O

E.Reduced CPU utilization

A.Stateless alerts can be cleared manually.

B.Stateful alerts must be cleared by a DBA after resolving the problem.

C.Stateless alerts are automatically cleared.

D.Stateful alerts are purged automatically from the alert history.

E.Stateless alerts can be purged manually from the alert history.

A.after losing a SYSAUX tablespace data file

B.after losing all members of the CURRENT online redo log group

C.after losing all copies of the control file

D.after losing all members of an INACTIVE online redo log group

E.after losing an UNDO tablespace that is in use

A.Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

B.All metrics are instance related.

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

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

E.Metrics are statistical counts for a specific unit.

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