单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）Ato prevent the creation of an excessive number of scheduler job classesBto allow the Automated Maintenance Tasks to use system resources without any restrictionCto allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowDto prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
单选题
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）
A
to prevent the creation of an excessive number of scheduler job classes
B
to allow the Automated Maintenance Tasks to use system resources without any restriction
C
to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D
to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
参考解析
解析：
暂无解析
相关考题：
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
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
Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?() A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.B. In a PDB plan, subplans may be used with up to eight consumer groups.C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
Which Oracle Database component is audited by default if the unified Auditing option is enabled?() A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security
Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）A、Oracle Data PumpB、Oracle Recovery Manager (RMAN)C、Oracle Label SecurityD、Oracle Database VaultE、Oracle Real Application Security
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this？（） A、 to prevent the creation of an excessive number of scheduler job classesB、 to allow the Automated Maintenance Tasks to use system resources without any restrictionC、 to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD、 to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
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
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement： SQLALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’； What will be the outcome of this statement？（） A、 The statement will deactivate DAY_PLAN.B、 The statement will activate DAY_PLAN as the top plan.C、 The statement will activate MANAGERS_PLAN as the top plan.D、 The statement will return an error because MANAGERS_PLAN is not the top plan.
Which of these represent the main components of Database Resource Manager？（）A、 Resource consumer groupsB、 Resource plansC、 Resource-plan groupsD、 Resource-plan directivesE、 All of the above
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（） A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）A、CPU usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
For which two situations would you use functionality provided by the Resource Manager？（）A、 setting idle timeout limits on resource plansB、 saving storage space by using compressed backup setsC、 creating jobs that will run automatically at a scheduled timeD、 assigning priorities to jobs to manage access to system resourcesE、 creating alerts to perform notification when tablespaces are low on available space resources
单选题You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）AOracle Management AgentBEnterprise Manager with Grid ControlCEnterprise Manager with Database ControlDOperating System Socket for incoming requestsEReal Application Cluster （RAC） with three instancesFEnterprise Manager with Generic Database Management
多选题Which of these represent the main components of Database Resource Manager？（）AResource consumer groupsBResource plansCResource-plan groupsDResource-plan directivesEAll of the above
单选题You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）A The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
单选题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
多选题For which two situations would you use functionality provided by the Resource Manager?（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources
单选题Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）AOracle Data PumpBOracle Recovery Manager (RMAN)COracle Label SecurityDOracle Database VaultEOracle Real Application Security
单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?（）AThe database must be running in ARCHIVELOG mode.BNo special setup is required, and the feature is enabled by default.CThe path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.DThe Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.ESelect the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
多选题Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）AIf no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.BIn a PDB plan, subplans may be used with up to eight consumer groups.CIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.DIf no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.EIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A assign users to consumer groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives
单选题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.
多选题In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
单选题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 have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）Aassign users to consumer groupsBset the resource plan for the instanceCconfigure a simple resource plan and specify plan directivesDconfigure a complex resource plan and specify plan directives
单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this？（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated Maintenance Tasks to use system resources without any restrictionC to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
多选题You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
单选题You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）AThe Resource Manager plan does not affect the user.BThere must be a plan directive in any of the plans of the group to control the resources.CThe members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.DThe members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.EThe members of this group can change their group without the database administrator’s intervention.