According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

单项选择题You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）

A.Use the Database Resource Manager.
B.Set the limits in the profiles used by users.
C.Modify the SESSIONS initialization parameter.
D.Set the warning threshold for the Current Logons Count metric.

单项选择题Theapplicationworkloadonyourdatabaseissamebetween10a.m.and11a.m.onweekdays.Suddenlyyouobservepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings，workloadprofile，andstatisticstodiagnosethepossiblecausesoftheperformancedegradation？（）

A.by using the SQL access advisor
B.by using the Automatic Workload Repository report
C.by running the Automatic Database Diagnostic Monitor （ADDM）
D.by using the Automatic Workload Repository Compare Period report
E.by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

单项选择题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task？（）

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.

单项选择题Inyourdatabase，theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting？（）

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.

单项选择题InwhichsituationwouldyouusetheOracleSharedServerconfiguration？（）

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