nerdexam
Oracle

1Z0-060 · Question #104

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

The correct answer is C. Parallel server limit D. CPU E. Exadata I/O. This question tests which specific resource types can be managed between competing PDBs using an Oracle Database Resource Manager CDB plan.

New Features for Manageability

Question

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

Options

  • AMaximum Undo per consumer group
  • BMaximum Idle time
  • CParallel server limit
  • DCPU
  • EExadata I/O
  • FLocal file system I/O

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    90% (19)

Why each option

This question tests which specific resource types can be managed between competing PDBs using an Oracle Database Resource Manager CDB plan.

AMaximum Undo per consumer group

Maximum Undo per consumer group is a directive scoped to standard resource plans within a single PDB, not available at the CDB plan level for inter-PDB resource governance.

BMaximum Idle time

Maximum Idle time is a consumer group attribute used in intra-PDB resource plans to terminate idle sessions, and is not a resource type configurable in CDB resource plan directives.

CParallel server limitCorrect

Parallel server limit is a valid CDB plan directive that controls how many parallel execution servers a given PDB is allowed to use, preventing one PDB from monopolizing parallel query resources.

DCPUCorrect

CPU is the foundational resource managed by Oracle Resource Manager in CDB plans, where shares or utilization limits can be assigned per PDB to ensure fair CPU allocation under contention.

EExadata I/OCorrect

Exadata I/O is a supported CDB plan resource on Oracle Exadata Database Machine, allowing I/O bandwidth to be distributed across competing PDBs using IORM-integrated directives.

FLocal file system I/O

Local file system I/O is not a supported resource type in CDB plan directives; Oracle Resource Manager only exposes Exadata I/O at the CDB plan level, not generic local I/O.

Concept tested: Oracle Resource Manager CDB plan resource directives

Source: https://docs.oracle.com/database/121/ADMIN/cdbresource.htm

Topics

#CDB resource manager#PDB resource plan#parallel server limit#Exadata I/O

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice