Oracle Database Administration II — Question 108

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

Answer options

• A. A PDB-level resource plan can limit session PGA memory.
• B. A CDB-level resource plan can limit PDB CPU utilization.
• C. A CDB-level resource plan can limit session CPU utilization.
• D. PDB-level resource plans can limit uncommitted UNDO per consumer group.
• E. A CDB-level resource plan can limit PDB UNDO use.
• F. A CDB-level resource plan is mandatory when using PDB-level resource plans.

Correct answer: C, E, F

Explanation

The correct answers are C, E, and F because a CDB-level resource plan does indeed manage session CPU utilization, limit PDB UNDO use, and is necessary when PDB-level plans are employed. Options A, B, and D are inaccurate as they misrepresent the capabilities of resource plans at the CDB and PDB levels.