Which statement is true regarding the creation of nested plans using the Oracle Resource
Manager?
A.
Only one nested subplan is allowed per parent plan
B.
The plans can be nested up to four levels.
C.
Nested plans only control resources used by recursive SQL
D.
Nested plans control only the degree of parallelism and I/O requests
E.
Each nested plan gets a proportion of the CPU resources assigned to its parent group.