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.
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.
相关考题：
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 thresholdB. Implement Database Resource ManagerC. Enable resumable timeout for user sessionsD. Add directives to Automatic Database Diagnostic Monitor (ADDM)
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?() A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile
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.
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 usersB、By implementing Fine-Grained Auditing （FGA）C、By granting a secure application role to the usersD、By implementing the Database Resource Manager plan
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 thresholdB、Implement Database Resource ManagerC、Enable resumable timeout for user sessionsD、Add directives to Automatic Database Diagnostic Monitor (ADDM)
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$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
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.
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 classesB、Implement Scheduler windowsC、Implement the mapping rule for the consumer groupsD、Set the SWITCH_TIME resource plan directive for both the resource plans
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.
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 usersB、Set the RESOURCE_LIMIT parameter to TRUE in the parameter fileC、Create a new profile with CPU restrictions and assign it to the usersD、Specify the users as members of the DEFAULT_CONSUMER_GROUPE、Revoke the DBA role and grant CONNECT and RESOURCE role to the users
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A、Use the DROP DATAFILE command.B、Use the DROP TABLESPACE command.C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）A、NLSLANGB、NLSLENGTHSEMANTICSC、NLSTERRITORYD、NLSLANGUAGEE、NLSCHARACTERSETF、NLSDATELANGUAGEG、NLSNCHARCHARACTERSET
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 windowsC、Implement the mapping rule for the consumer groups D、Set the SWITCH_TIME resource plan directive for both the resource plans
In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME 2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME 3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER 4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME How would you accomplish the above（）A、by assigning profiles for the usersB、by implementing Fine-Grained Auditing （FGA）C、by granting a secure application role to the usersD、by implementing the Database Resource Manager plan
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase 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 automaticpurging of snapshots
Terminal Services application runs on the server. Users report that the application stops responding. You monitor the memory usage on the server for a week. You discover that the application has a memory leak. A patch is not currently available. You create a new resource-allocation policy in Microsoft Windows Server Resource Manager. You configure a Process Matching Criteria named TrackShip and select the application. You need to terminate the application when the application consumes more than half of the available memory on the server. What should you do？（）A、Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Profiling Policy.B、Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Managing Policy.C、Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Profiling Policy.D、Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Managing Policy.
单选题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（）ABy assigning profiles for the usersBBy implementing Fine-Grained Auditing （FGA）CBy granting a secure application role to the usersDBy implementing the Database Resource Manager plan
单选题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？（）AAssign the DEFAULT profile to the usersBSet the RESOURCE_LIMIT parameter to TRUE in the parameter fileCCreate a new profile with CPU restrictions and assign it to the usersDSpecify the users as members of the DEFAULT_CONSUMER_GROUPERevoke the DBA role and grant CONNECT and RESOURCE role to the users
单选题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?（）AImplement job classesBImplement Scheduler windowsCImplement the mapping rule for the consumer groupsDSet the SWITCH_TIME resource plan directive for both the resource plans
单选题You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）ANLSLANGBNLSLENGTHSEMANTICSCNLSTERRITORYDNLSLANGUAGEENLSCHARACTERSETFNLSDATELANGUAGEGNLSNCHARCHARACTERSET
单选题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? （）AImplement job classes BImplement Scheduler windowsCImplement the mapping rule for the consumer groups DSet the SWITCH_TIME resource plan directive for both the resource plans
单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）ASetting a metric thresholdBImplementing Database Resource ManagerCEnabling resumable timeout for user sessionsDDecreasing the value of the IDLE_TIME resource limit in the default profile
单选题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?（）ASet metric thresholdBImplement Database Resource ManagerCEnable resumable timeout for user sessionsDAdd directives to Automatic Database Diagnostic Monitor (ADDM)
单选题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？（）AUse the Database Resource Manager.BSet the limits in the profiles used by users.CModify the SESSIONS initialization parameter.DSet the warning threshold for the Current Logons Count metric.
单选题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（）AYou would configure more listeners for the database.BYou would configure the database in shared server mode to use the connection pooling feature.CYou would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.DYou would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
单选题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？（）AYou need to perform the restore and recover operations manually, because the backup was made manually. BFirst you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. CFirst you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. DYou can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
单选题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$SYSSTATB V$SESSSTATC V$RSRC_PLAND V$RSRC_CONSUMER_GROUP