A.Set the STATISTICS_LEVEL initialization parameter to ALL.
B.Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.
C.Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

A.The optimizer statistics are collected automatically.
B.Only the timed operating system （OS） statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A.when performing export and import using Oracle Data Pump
B.when performing backup and recovery operations using Oracle Recovery Manager
C.when performing batch processing and bulk loading operation in a data warehouse environment 
D.in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

A.The sessions are able to perform only queries.
B.The sessions are not affected and continue to function normally.
C.The active transactions are rolled back and the sessions get terminated.
D.The sessions are not allowed to perform any operations till the listener is started.

A.to enable operating system authentication for a remote client
B.to restrict the scope of administration to identical operating systems
C.to allow the start up and shut down of the database from a remote client
D.to enable the administration of the operating system from a remote client
E.to disable the administration of the operating system from a remote client

A.More than one database is to be registered with the listener.
B.The users will connect the database by using the host naming method.
C.The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D.The database that is to be registered with the listener is configured in shared server mode.
E.The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

A.FGA is possible on SELECT statements only.
B.The audit trail for FGA is stored in the FGA_LOG$ table.
C.The audit trail for FGA is stored in the AUD_LOG$ table.
D.FGA enables a SQL predicate to define when to audit an event.
E.FGA audits DELETE statements only when audit columns are specified.
F.FGA includes the SQL statement used by the user as part of the audit event entry.

A.implementing value­based auditing by using triggers
B.implementing fine­grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS

A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits.