单选题You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）A 45.5B 65C 70D 100
单选题
You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）
A
45.5
B
65
C
70
D
100
参考解析
解析：
暂无解析
相关考题：
Within a resource－plan definition, what differentiates a top－level plan from a subplan?() A. A subplan has the PLAN_SUB parameter value set to SUBB. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC. There is no difference in the resource-plan definitionD. A subplan always has the CPU_MTH parameter value set to RATIOE. The string TOP_LEVEL is appended to the name of top-level resource plans
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.
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
Within a resource-plan definition, what differentiates a top-level plan from a subplan?（）A、A subplan has the PLAN_SUB parameter value set to SUBB、A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC、There is no difference in the resource-plan definitionD、A subplan always has the CPU_MTH parameter value set to RATIOE、The string TOP_LEVEL is appended to the name of top-level resource plans
You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（） A、 45.5B、 65C、 70D、 100
You execute the following block of code： SQLBEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN = ’DEPARTMENTS’， CONSUMER_GROUP1 = ’PAYROLLL’， GROUP1_CPU = 50， CONSUMER_GROUP2 = ’SALES’， GROUP2_CPU = 25， CONSUMER_GROUP3 = ’MARKETING’， GROUP3_CPU = 25）； END； SQL/ What is a prerequisite for using the simple resource plan created by executing the above code？（）A、 You must assign users to consumer groups.B、 You must grant the switch privilege to the users.C、 You must create a resource plan directive.D、 You must specify the complex resource plan.
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.
You have created a resource plan， DAY. You execute the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（） A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D、 The second code will not execute because one resource plan cannot be used by more than one subplan.
Which statement is true while creating subplans using Resource Manager？（）A、 The subplan must belong to the consumer group， SYS_GROUP.B、 The total CPU usage at any given level must be less than 100%.C、 The subplans can be used to restrict the degree of parallelism for a user.D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
You plan to deploy a RemoteApp solution. You plan to install the Remote Desktop Session Host （RD Session Host） role service on a server named Server1 You need to recommend a solution that prevents a single connection to Server1 from using more than 10 percent of the available CPU resources on the server. What should you include in the recommendation？（）A、Windows System Resource Manager （WSRM）B、Microsoft System Center Operations ManagerC、Microsoft System Center Virtual Machine ManagerD、Microsoft Application Virtualization （App-V）
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server hosts databases for several mission-critical applications. Microsoft SQL Server Management Studio executes queries and it has some effect. Now you intend to limit the effect by using the Resource Governor. You must make sure that queries initiated through SQL Server Management Studio is less than 20 percent of CPU utilization, besides this, you must make sure that queries initiated by the mission-critical applications can consume 100 percent of CPU utilization when required. So what action should you perform to achieve this goal? （）A、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio. B、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio. C、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications. D、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2. A server named Server1 has the Remote Desktop Services server role installed. You notice that several users consume more than 30 percent of the CPU resources throughout the day. You need to prevent users from consuming more than 15 percent of the CPU resources. Administrators must not be limited by the amount of CPU resources that they can consume. What should you do？（）A、Implement Windows System Resource Manager （WSRM），and configure user policies.B、Implement Windows System Resource Manager （WSRM），and configure session policies.C、Configure Performance Monitor，and create a user-defined Data Collector Set.D、Configure Performance Monitor，and create an Event Trace Session Data Collector Set.
You manage a member server that runs Windows Server 2008. The server has the Terminal Services role installed. Microsoft Windows System Resource Manager （WSRM） is installed on the server. Users report performance degradation on the Terminal Server. You monitor the server and notice that one user is consuming 100 percent of the processor time. You create a resource-allocation policy named Policy1 that limits each user to 30 percent of the total processor time. You observe no performance improvement. You need to configure WSRM to enforce Policy1. What should you do？（）A、Set Policy1 as the Profiling Policy.B、Set Policy1 as the Managing Policy.C、Restart the Terminal Services Configuration service.D、Launch the WSRM application by using the user context of the Terminal Server System account.
单选题You plan to deploy a RemoteApp solution. You plan to install the Remote Desktop Session Host （RD Session Host） role service on a server named Server1 You need to recommend a solution that prevents a single connection to Server1 from using more than 10 percent of the available CPU resources on the server. What should you include in the recommendation？（）AWindows System Resource Manager （WSRM）BMicrosoft System Center Operations ManagerCMicrosoft System Center Virtual Machine ManagerDMicrosoft Application Virtualization （App-V）
单选题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.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server hosts databases for several mission-critical applications. Microsoft SQL Server Management Studio executes queries and it has some effect. Now you intend to limit the effect by using the Resource Governor. You must make sure that queries initiated through SQL Server Management Studio is less than 20 percent of CPU utilization, besides this, you must make sure that queries initiated by the mission-critical applications can consume 100 percent of CPU utilization when required. So what action should you perform to achieve this goal? （）AYou should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio. BFirst, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio. CYou should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications. DFirst, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
单选题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
单选题You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE （PLAN = ’DSS_PLAN’， GROUP_OR_SUBPLAN = ’DSS_USERS’， NEW_CPU_P1 = 80， NEW_SWITCH_GROUP = ’CANCEL_SQL’， NEW_SWITCH_ESTIMATE = TRUE， NEW_SWITCH_TIME = 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）A The session is killed before starting the operation.B The session generates an error before starting the operation.C The session switches to the CANCEL_SQL resource consumer group before starting the operation.D The session hangs before starting the operation.
单选题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 have created a resource plan， DAY. You execute the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（）A The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D The second code will not execute because one resource plan cannot be used by more than one subplan.
单选题Which statement is true while creating subplans using Resource Manager？（）A The subplan must belong to the consumer group， SYS_GROUP.B The total CPU usage at any given level must be less than 100%.C The subplans can be used to restrict the degree of parallelism for a user.D You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
单选题Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2. A server named Server1 has the Remote Desktop Services server role installed. You notice that several users consume more than 30 percent of the CPU resources throughout the day. You need to prevent users from consuming more than 15 percent of the CPU resources. Administrators must not be limited by the amount of CPU resources that they can consume. What should you do？（）AImplement Windows System Resource Manager （WSRM），and configure user policies.BImplement Windows System Resource Manager （WSRM），and configure session policies.CConfigure Performance Monitor，and create a user-defined Data Collector Set.DConfigure Performance Monitor，and create an Event Trace Session Data Collector Set.
单选题Within a resource-plan definition， what differentiates a top-level plan from a subplan？（）A A subplan has the PLAN_SUB parameter value set to SUBB A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC There is no difference in the resource-plan definitionD A subplan always has the CPU_MTH parameter value set to RATIOE The string TOP_LEVEL is appended to the name of top-level resource plans
单选题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
单选题You manage a member server that runs Windows Server 2008. The server has the Terminal Services role installed. Microsoft Windows System Resource Manager （WSRM） is installed on the server. Users report performance degradation on the Terminal Server. You monitor the server and notice that one user is consuming 100 percent of the processor time. You create a resource-allocation policy named Policy1 that limits each user to 30 percent of the total processor time. You observe no performance improvement. You need to configure WSRM to enforce Policy1. What should you do？（）ASet Policy1 as the Profiling Policy.BSet Policy1 as the Managing Policy.CRestart the Terminal Services Configuration service.DLaunch the WSRM application by using the user context of the Terminal Server System account.
单选题You execute the following block of code： SQLBEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN = ’DEPARTMENTS’， CONSUMER_GROUP1 = ’PAYROLLL’， GROUP1_CPU = 50， CONSUMER_GROUP2 = ’SALES’， GROUP2_CPU = 25， CONSUMER_GROUP3 = ’MARKETING’， GROUP3_CPU = 25）； END； SQL/ What is a prerequisite for using the simple resource plan created by executing the above code？（）A You must assign users to consumer groups.B You must grant the switch privilege to the users.C You must create a resource plan directive.D You must specify the complex resource plan.