assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第1题:
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?()
第2题:
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?()
第3题:
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?()
第4题:
You have a computer that runs Windows 7. You need to identify the disk, memory, CPU, and networkresources that an application is currently using. Which tool should you use?()
第5题:
RATIO
EMPHASIS
ACTIVE_SESS_POOL_MTH
RESOURCE_DEGREE_LIMIT_ABSOLUTE
第6题:
The user must have been granted the DBA role.
The user must have been granted the switch privilege as a part of a role.
The user must have been granted the Resource Manager administrator privilege.
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
第7题:
The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.
The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
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.
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.
第8题:
The user must have been granted the DBA role.
The user must have been granted the switch privilege as a part of a role.
The user must have been granted the Resource Manager administrator privilege.
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
第9题:
A window must have been created with the WEEKEND_PLAN resource plan.
A program must have been created with the WEEKEND_PLAN resource plan.
A job class must have been created with the WEEKEND_PLAN resource plan.
A windows group must have been created with the WEEKEND_PLAN resource plan.
第10题:
CPU usage
degree of parallelism
number of open cursors
number of sorts performed
idle time for blocking sessions
number of disk I/O operations performed
number of memory I/O operations performed
第11题:
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.
The members of the HIGH_CG consumer group would get 10% of the CPU.
The plan PROD_DB_PLAN can have subplans.
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
第12题:
The Resource Manager plan does not affect the user.
There must be a plan directive in any of the plans of the group to control the resources.
The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.
The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.
The members of this group can change their group without the database administrator’s intervention.
第13题:
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: SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’; What will be the outcome of this statement?()
第14题:
Which statement is true while creating subplans using Resource Manager?()
第15题:
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?()
第16题:
The statement will deactivate DAY_PLAN.
The statement will activate DAY_PLAN as the top plan.
The statement will activate MANAGERS_PLAN as the top plan.
The statement will return an error because MANAGERS_PLAN is not the top plan.
第17题:
45.5
65
70
100
第18题:
You must assign users to consumer groups.
You must grant the switch privilege to the users.
You must create a resource plan directive.
You must specify the complex resource plan.
第19题:
V$SYSSTAT
V$SESSSTAT
V$RSRC_PLAN
V$RSRC_CONSUMER_GROUP
第20题:
The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
The second code will not execute because one resource plan cannot be used by more than one subplan.
第21题:
assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第22题:
The subplan must belong to the consumer group, SYS_GROUP.
The total CPU usage at any given level must be less than 100%.
The subplans can be used to restrict the degree of parallelism for a user.
You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
第23题:
CPU usage
degree of parallelism
number of open cursors
number of sorts performed
idle time for blocking sessions
number of disk I/O operations performed
number of memory I/O operations performed