1Z0-083 · Question #152
Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)
The correct answer is A. A PDB-level resource plan can limit session PGA memory. B. A CDB-level resource plan can limit PDB CPU utilization. D. PDB-level resource plans can limit uncommitted UNDO per consumer group. AB correct - no doubts D is correct instead of C, because - on the PDB level you manage resources more/less the same as in non-CDB database hence you can limit uncommitted UNDO per consumer group: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11853 while from CDB…
Question
Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)
Options
- AA PDB-level resource plan can limit session PGA memory.
- BA CDB-level resource plan can limit PDB CPU utilization.
- CA CDB-level resource plan can limit session CPU utilization.
- DPDB-level resource plans can limit uncommitted UNDO per consumer group.
- EA CDB-level resource plan can limit PDB UNDO use.
- FA CDB-level resource plan is mandatory when using PDB-level resource plans.
How the community answered
(28 responses)- A79% (22)
- C11% (3)
- E7% (2)
- F4% (1)
Explanation
AB correct - no doubts D is correct instead of C, because - on the PDB level you manage resources more/less the same as in non-CDB database hence you can limit uncommitted UNDO per consumer group: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11853 while from CDB level you cannot limit CPU on particular session level in PDB (it can be done on PDB level) but you can "only" limit CPU generally for particular PDB: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource- manager-for-pdbs-with-sql-plus.html#GUID-19400E80-882F-424F-A19A-9FEB54F83577
Topics
Community Discussion
No community discussion yet for this question.