nerdexam
Oracle

1Z0-043 · Question #37

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…

The correct answer is C. The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU E. The maximum degree of parallelism for the members of the consumer group SALES is 4 with no. See the full explanation below for the reasoning.

Question

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? (Choose two.)

Options

  • 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
  • DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2
  • EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    10% (3)
  • C
    79% (23)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice