When creating a plan directive, which of the following resource allocation methods are valid when the target of the directive is a sub-plan?
Execution time limit
Undo pool
Automatic consumer group switching
Canceling SQL and terminating sessions
CPU method
Which of the following is not a valid consumer group mapping attribute?
CLIENT_OS_USER
MODULE_NAME
CLIENT_PROGRAM
MODULE_ACTION
SERVICE_MODULE_ACTION
Which of the following methods of CPU allocation can be defined for a single-level resource plan?
RATIO
EMPHASIS
BASIC
A, B, and C
Both A and B
What is the effect of the following statement? ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'FORCE:NIGHT_PLAN';
DRM will be enabled with NIGHT_PLAN as the top-level plan. Changes to the top-level plan will be restricted.
NIGHT_PLAN will be moved into the data dictionary, and DRM will be enabled with NIGHT_PLAN as the top-level plan. Changes to the top-level plan will be restricted.
The current DRM top-level plan will be changed to NIGHT_PLAN, in spite of restrictions.
NIGHT_PLAN will be moved into the data dictionary, and the current DRM top-level plan will be changed to NIGHT_PLAN, in spite of restrictions.
NIGHT_PLAN will be made active.
A simple resource plan can define how many CPU allocation levels?
1
2
4
8
16
A session assigned to the MARKETING group is switched to the LOW_GROUP because it exceeded the execution time set in the SWITCH_TIME_IN_CALL parameter of the plan directive. When the long-running operation completes, which group will the session be assigned to?
MARKETING
LOW_GROUP
DEFAULT_GROUP
None, the session would have been killed.
Where are active DRM objects are located?
V$ tables
Pending area
Data dictionary
DRM_OBJECTS table
None of the above
Consumer groups can be automatically assigned to sessions based on the mappings created through which DBMS_RESOURCE_MANAGER procedure?
CREATE_CONSUMER_GROUP_MAPPING
CREATE_GROUP_MAPPING
SET_CONSUMER_GROUP_MAPPING
MAP_CONSUMER_GROUPS
CREATE_CONSUMER_RSRC_GROUP_MAPPING
Every resource plan must contain an allocation to which consumer group?
LOW_GROUP
SYS_GROUP
DEFAULT_GROUP
BASE_GROUP
OTHER_GROUPS
Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer group mappings?
CREATE_MAPPING_PRIORITY
SET_MAPPING_PRIORITY
SET_MAPPING_ORDER
PRIORITIZE_MAPPING_ORDER
This functionality is not available through the DBMS_RESOURCE_MANAGER package.
Which of the following are valid methods of switching consumer groups for one or more sessions? (Choose all that apply.)
SWITCH_CONSUMER_GROUP_FOR_SESS procedure of DBMS_RESOURCE_MANAGER
SWITCH_CONSUMER_GROUPS procedure of DBMS_RESOURCE_MANAGER
SWITCH_CONSUMER_GROUP_FOR_USER procedure of DBMS_RESOURCE_MANAGER
ALTER SESSION SWITCH CONSUMER GROUP command
All of the above
If a session is assigned to a consumer group that is not included in the enabled plan, which group will it be considered part of?
None
BASE_GROUP
DEFAULT_GROUP
OTHER_GROUPS
SWITCH_GROUP
Within a resource plan definition, what differentiates a top-level plan from a sub-plan?
A sub-plan has the PLAN_SUB parameter value set to SUB.
A top-level plan has the GROUP_OR_PLAN parameter set to the name of the sub-plan in the resource plan definition.
There is no difference in the resource plan definition.
A sub-plan always has the CPU_MTH parameter value set to RATIO.
The string TOP_LEVEL is appended to the name of top-level resource plans.
Which DBMS_RESOURCE_MANAGER procedure deletes a plan along with all of its subordinate objects?
DELETE_PLAN_CASCADE
DELETE_RESOURCE_PLAN_CASCADE
DROP_PLAN
DROP_PLAN_CASCADE
Subordinate objects must be deleted separately.
Which DRM object ties a plan to a resource group and also defines the allocation method to be utilized?
Resource plan
Resource plan directive
Resource plan rule
Consumer group directive
None of the above
Which view displays the resource consumer groups currently assigned to sessions?
V$SESS_GROUP
DBA_RSRC_GROUP
DBA_RSRC_PLANS
V$RSRC_CONSUMER_GROUPS
V$SESSION
The switch privilege can be granted to a user or role by using which method(s)? (Choose all that apply.)
GRANT statement
DBMS_RESOURCE_MANAGER procedure
DBMS_RESOURCE_MANAGER_PRIVS procedure
DBMS_SESSION procedure
All of the above
Which of the following statements are true regarding users who have been granted the switch privilege? (Choose all that apply.)
They can switch only to a consumer group with equal or lower priority.
They can switch the group for any session as long as they have been granted the privilege ADMIN option.
They can switch to any consumer group for which they have been granted the switch privilege.
They can grant the switch privilege to another user if they have been granted the privilege with the ADMIN option.
All of the above are true.
If the switch privilege has been granted to PUBLIC for a specific consumer group, which of the following statements is true?
Any user assigned to that group can switch to another group.
Any user can switch to the specified group.
Any user with a SWITCH_PUBLIC grant can switch to the specified group.
Both A and B are true.
A, B, and C are true.