Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

Question

Options

• AOnly one nested subplan is allowed per parent plan
• BThe plans can be nested up to four levels.
• CNested plans only control resources used by recursive SQL
• DNested plans control only the degree of parallelism and I/O requests
• EEach nested plan gets a proportion of the CPU resources assigned to its parent group.

• A
  3% (1)
• B
  12% (4)
• C
  3% (1)
• D
  6% (2)
• E
  76% (25)

No community discussion yet for this question.