11.9. Review Questions

  1. Which system privileges allow you to administer the Database Resource Manager?

    1. DBA

    2. ADMINISTER_ANY_RESOURCE

    3. ADMINISTER_RESOURCE_MANAGER

    4. RESOURCE_MANAGER_ADMIN

    5. All of the above

  2. When creating a plan directive, which of the following resource allocation methods are valid when the target of the directive is a sub-plan?

    1. Execution time limit

    2. Undo pool

    3. Automatic consumer group switching

    4. Canceling SQL and terminating sessions

    5. CPU method

  3. Which of the following is not a valid consumer group mapping attribute?

    1. CLIENT_OS_USER

    2. MODULE_NAME

    3. CLIENT_PROGRAM

    4. MODULE_ACTION

    5. SERVICE_MODULE_ACTION

  4. Which of the following methods of CPU allocation can be defined for a single-level resource plan?

    1. RATIO

    2. EMPHASIS

    3. BASIC

    4. A, B, and C

    5. Both A and B

  5. What is the effect of the following statement? ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'FORCE:NIGHT_PLAN';

    1. DRM will be enabled with NIGHT_PLAN as the top-level plan. Changes to the top-level plan will be restricted.

    2. 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.

    3. The current DRM top-level plan will be changed to NIGHT_PLAN, in spite of restrictions.

    4. 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.

    5. NIGHT_PLAN will be made active.

  6. A simple resource plan can define how many CPU allocation levels?

    1. 1

    2. 2

    3. 4

    4. 8

    5. 16

  7. 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?

    1. MARKETING

    2. LOW_GROUP

    3. DEFAULT_GROUP

    4. None, the session would have been killed.

  8. Where are active DRM objects are located?

    1. V$ tables

    2. Pending area

    3. Data dictionary

    4. DRM_OBJECTS table

    5. None of the above

  9. Consumer groups can be automatically assigned to sessions based on the mappings created through which DBMS_RESOURCE_MANAGER procedure?

    1. CREATE_CONSUMER_GROUP_MAPPING

    2. CREATE_GROUP_MAPPING

    3. SET_CONSUMER_GROUP_MAPPING

    4. MAP_CONSUMER_GROUPS

    5. CREATE_CONSUMER_RSRC_GROUP_MAPPING

  10. Every resource plan must contain an allocation to which consumer group?

    1. LOW_GROUP

    2. SYS_GROUP

    3. DEFAULT_GROUP

    4. BASE_GROUP

    5. OTHER_GROUPS

  11. Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer group mappings?

    1. CREATE_MAPPING_PRIORITY

    2. SET_MAPPING_PRIORITY

    3. SET_MAPPING_ORDER

    4. PRIORITIZE_MAPPING_ORDER

    5. This functionality is not available through the DBMS_RESOURCE_MANAGER package.

  12. Which of the following are valid methods of switching consumer groups for one or more sessions? (Choose all that apply.)

    1. SWITCH_CONSUMER_GROUP_FOR_SESS procedure of DBMS_RESOURCE_MANAGER

    2. SWITCH_CONSUMER_GROUPS procedure of DBMS_RESOURCE_MANAGER

    3. SWITCH_CONSUMER_GROUP_FOR_USER procedure of DBMS_RESOURCE_MANAGER

    4. ALTER SESSION SWITCH CONSUMER GROUP command

    5. All of the above

  13. 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?

    1. None

    2. BASE_GROUP

    3. DEFAULT_GROUP

    4. OTHER_GROUPS

    5. SWITCH_GROUP

  14. Within a resource plan definition, what differentiates a top-level plan from a sub-plan?

    1. A sub-plan has the PLAN_SUB parameter value set to SUB.

    2. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the sub-plan in the resource plan definition.

    3. There is no difference in the resource plan definition.

    4. A sub-plan always has the CPU_MTH parameter value set to RATIO.

    5. The string TOP_LEVEL is appended to the name of top-level resource plans.

  15. Which DBMS_RESOURCE_MANAGER procedure deletes a plan along with all of its subordinate objects?

    1. DELETE_PLAN_CASCADE

    2. DELETE_RESOURCE_PLAN_CASCADE

    3. DROP_PLAN

    4. DROP_PLAN_CASCADE

    5. Subordinate objects must be deleted separately.

  16. Which DRM object ties a plan to a resource group and also defines the allocation method to be utilized?

    1. Resource plan

    2. Resource plan directive

    3. Resource plan rule

    4. Consumer group directive

    5. None of the above

  17. Which view displays the resource consumer groups currently assigned to sessions?

    1. V$SESS_GROUP

    2. DBA_RSRC_GROUP

    3. DBA_RSRC_PLANS

    4. V$RSRC_CONSUMER_GROUPS

    5. V$SESSION

  18. The switch privilege can be granted to a user or role by using which method(s)? (Choose all that apply.)

    1. GRANT statement

    2. DBMS_RESOURCE_MANAGER procedure

    3. DBMS_RESOURCE_MANAGER_PRIVS procedure

    4. DBMS_SESSION procedure

    5. All of the above

  19. Which of the following statements are true regarding users who have been granted the switch privilege? (Choose all that apply.)

    1. They can switch only to a consumer group with equal or lower priority.

    2. They can switch the group for any session as long as they have been granted the privilege ADMIN option.

    3. They can switch to any consumer group for which they have been granted the switch privilege.

    4. They can grant the switch privilege to another user if they have been granted the privilege with the ADMIN option.

    5. All of the above are true.

  20. If the switch privilege has been granted to PUBLIC for a specific consumer group, which of the following statements is true?

    1. Any user assigned to that group can switch to another group.

    2. Any user can switch to the specified group.

    3. Any user with a SWITCH_PUBLIC grant can switch to the specified group.

    4. Both A and B are true.

    5. A, B, and C are true.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset