Which statement is true while creating subplans using Resource Manager?
The subplan must belong to the consumer group, SYS_GROUP.
The total CPU usage at any given level must be less than 100%.
The subplans can be used to restrict the degree of parallelism for a user.
You can use a resource plan instead of a consumer group to implement a priority ranking
within the plan.