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 limit

第1题：

Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）

• A、Insert finding directives for ADDM tasks in the future.
• B、Create a baseline on a pair of snapshots spanning the peak-load period.
• C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
• D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

第2题：

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）

• A、Set metric threshold
• B、Implement Database Resource Manager
• C、Enable resumable timeout for user sessions
• D、Add directives to Automatic Database Diagnostic Monitor (ADDM)

第3题：

第4题：

Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）

• A、You would configure more listeners for the database.
• B、You would configure the database in shared server mode to use the connection pooling feature.
• C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
• D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

第5题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第6题：

In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）

• A、By assigning profiles for the users
• B、By implementing Fine-Grained Auditing （FGA）
• C、By granting a secure application role to the users
• D、By implementing the Database Resource Manager plan

第7题：

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

• A、 V$SYSSTAT
• B、 V$SESSSTAT
• C、 V$RSRC_PLAN
• D、 V$RSRC_CONSUMER_GROUP

第8题：

第9题：

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）

• A、Implement job classes
• B、Implement Scheduler windows
• C、Implement the mapping rule for the consumer groups
• D、Set the SWITCH_TIME resource plan directive for both the resource plans

第10题：

You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

• A、Assign the DEFAULT profile to the users
• B、Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
• C、Create a new profile with CPU restrictions and assign it to the users
• D、Specify the users as members of the DEFAULT_CONSUMER_GROUP
• E、Revoke the DBA role and grant CONNECT and RESOURCE role to the users