多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH

考题 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

查看答案

考题 Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQLBEGINDBMS_SCHEDULER.CREATE_JOB_CLASS（JOB_CLASS_NAME=’LOW_PRIORITY_CLASS’，RESOURCE_CONSUMER_GROUP=’LOW_GROUP’，LOGGING_LEVEL=DBMS_SCHEDULER.LOGGING_FULL，LOG_HISTORY=1200，COMMENTS=’LOWJOBPRIORITYCLASS’）；END；SQL/Whatwillbetheresultoftheabovecommand？（）A.Thecommandwillbeexecutedsuccessfully.B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

查看答案

考题 Youexecutethefollowingblockofcode：SQLBEGINDBMS_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/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode？（）A.Youmustassignuserstoconsumergroups.B.Youmustgranttheswitchprivilegetotheusers.C.Youmustcreatearesourceplandirective.D.Youmustspecifythecomplexresourceplan.

查看答案

考题 You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？（）A、The maximum degree of parallelism for the members of the consumer groups is 4.B、The CPU allocation will always be equal for the consumer groups MARKET and DEV.C、The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.D、The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.E、The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

查看答案

考题 Every resource plan must contain an allocation to which consumer group？（）A、 LOW_GROUPB、 SYS_GROUPC、 DEFAULT_GROUPD、 BASE_GROUPE、 OTHER_GROUPS

查看答案

考题 You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） A、 CPU_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2

查看答案

考题 You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）A、 The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.B、 The members of the HIGH_CG consumer group would get 10% of the CPU.C、 The plan PROD_DB_PLAN can have subplans.D、 The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.

查看答案

考题 Which of the following objects can be directly referenced by a window object？（）A、 Schedule objectB、 Program objectC、 Job objectD、 Resource planE、 Resource consumer group

查看答案

考题 You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（） A、 The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B、 The job affinity is to a service and one node in that service is unavailable.C、 The job affinity is to an instance and that instance is unavailable.D、 There is no service affinity.E、 None 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 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.

查看答案

考题 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.

查看答案

考题 Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）A、SWITCH_TIMEB、SWITCH_GROUPC、MAX_SESS_POOLD、SWITCH_ESTIMATE

查看答案

考题 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 issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（） A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.D、The code will execute successfully but no privilege will be granted to the user， Scott.

查看答案

考题 In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）A、The parallel degree limit for DB_GRP will be the minimum of all the incoming values.B、The parallel degree limit for DB_GRP will be the maximum of all the incoming values.C、The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.D、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.E、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

查看答案

考题 You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）A、Increasing the priority of the job class to which the job belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs

查看答案

考题单选题You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）A The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B The job affinity is to a service and one node in that service is unavailable.C The job affinity is to an instance and that instance is unavailable.D There is no service affinity.E None of the above.

查看答案

考题多选题In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

查看答案

考题多选题In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？（）AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.EIs a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

查看答案

考题单选题You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（）A CPU_MTHB NEW_CPU_MTHC CPU_P1D CPU_P2

查看答案

考题多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE

查看答案

考题多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE

查看答案

考题单选题Every resource plan must contain an allocation to which consumer group？（）A LOW_GROUPB SYS_GROUPC DEFAULT_GROUPD BASE_GROUPE OTHER_GROUPS

查看答案

考题多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？（）AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

查看答案

考题单选题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 notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs

查看答案

考题单选题You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（）A The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.B The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.C The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.D The code will execute successfully but no privilege will be granted to the user， Scott.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：