网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Every resource plan must contain an allocation to which consumer group？（）
A
LOW_GROUP
B
SYS_GROUP
C
DEFAULT_GROUP
D
BASE_GROUP
E
OTHER_GROUPS
参考答案
参考解析
解析：
暂无解析
更多 “单选题Every resource plan must contain an allocation to which consumer group？（）A LOW_GROUPB SYS_GROUPC DEFAULT_GROUPD BASE_GROUPE OTHER_GROUPS” 相关考题
考题
Which three statements are true about windows?()
A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
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
考题
Which three statements are true about windows? ()(Choose three.)
A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various time periods.
考题
A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（） A、 Multiple application servers must be in a single resource group.B、 Multiple application servers per resource group may be monitored.C、 Multiple resource groups must each contain a single application server.D、 Multiple application servers in a cluster cannot use process monitoring.
考题
Which three statements are true about terms in a policy?（）A、The order of the terms in a policy is irrelevantB、The action is specified in a then statementC、Ters are optional in a policyD、The match condition can be identified with a from statementE、Every policy must contain at least one term
考题
Which three are the valid statements in relation to SQL plan baselines?（）A、The plans can be manually loaded to the SQL plan baseline.B、The plans in the SQL plan baseline are verified and accepted plans.C、The plans generated for every SQL statement are stored in the SQL plan baseline by default.D、The plan baselines are stored temporarily in the memory as long as the database instance is running.E、 For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
考题
Which two statements are true about the security-related tags in a valid Java EE deployment descriptor？（）A、Every tag must have at least one tag.B、A tag can have many tags.C、A given tag can apply to only one tag.D、A given tag can contain from zero to many tags.E、It is possible to construct a valid tag such that，for a given resource，no user rolescan access that resource.
考题
Which statement is true about terms in a policy?（）A、A single term can be applied to a protocol or interface, independent of the policyB、Every policy must contain at least one termC、The name of a term is limited to five charactersD、Terms are optional
考题
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
考题
Every resource plan must contain an allocation to which consumer group？（）A、 LOW_GROUPB、 SYS_GROUPC、 DEFAULT_GROUPD、 BASE_GROUPE、 OTHER_GROUPS
考题
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（） A、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
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 creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（） A、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
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.
考题
Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A windows group must have been created with the WEEKEND_PLAN resource plan.
考题
单选题You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）A
RATIOB
EMPHASISC
ACTIVE_SESS_POOL_MTHD
RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
单选题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 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 system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）A
WindowB
ProgramC
Job_ClassD
Window group
考题
单选题A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（）A
Multiple application servers must be in a single resource group.B
Multiple application servers per resource group may be monitored.C
Multiple resource groups must each contain a single application server.D
Multiple application servers in a cluster cannot use process monitoring.
考题
单选题Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）A
A window must have been created with the WEEKEND_PLAN resource plan.B
A program must have been created with the WEEKEND_PLAN resource plan.C
A job class must have been created with the WEEKEND_PLAN resource plan.D
A windows group must have been created with the WEEKEND_PLAN resource plan.
考题
单选题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， 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
考题
单选题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 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
考题
多选题Which three statements are true about windows? （）(Choose three.)AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during windows creationEWindows can automatically start job or change resource allocation among jobs for various time periods.
考题
多选题Which three statements are true about windows？（）AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during windows creationEWindows can automatically start job or change resource allocation among jobs for various time periods.
考题
多选题Which three are the valid statements in relation to SQL plan baselines?（）AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.E For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
热门标签
最新试卷
