1Z0-060 · Question #180
Which two are true concerning a multitenant container database with three pluggable databases?
The correct answer is B. Pluggable databases can make database consolidation easier E. Pluggable databases are patched together. In Oracle multitenant architecture, PDBs share a single Oracle binary and SGA, meaning they are patched together as a unit and simplify database consolidation compared to managing many non-CDB databases.
Question
Which two are true concerning a multitenant container database with three pluggable databases?
Options
- APluggable databases in the same container database (CDB) each have their own buffer cache
- BPluggable databases can make database consolidation easier
- CAll administration tasks must be done to each pluggable database.
- DPluggable databases increase patching time.
- EPluggable databases are patched together
How the community answered
(64 responses)- A5% (3)
- B91% (58)
- C2% (1)
- D3% (2)
Why each option
In Oracle multitenant architecture, PDBs share a single Oracle binary and SGA, meaning they are patched together as a unit and simplify database consolidation compared to managing many non-CDB databases.
PDBs in the same CDB share a single SGA including one buffer cache; they do not each have separate buffer caches - shared memory allocation is a core efficiency benefit of the multitenant architecture, not a per-PDB resource.
PDBs allow many databases to share a single set of Oracle background processes, memory structures, and administrative overhead, dramatically reducing the resources and effort required to consolidate dozens or hundreds of separate databases.
Many DBA tasks such as patching, RMAN backup, and system-level parameter changes are performed once at the CDB root level and apply to all PDBs simultaneously, so administration is not required individually for each PDB.
PDBs decrease patching time compared to equivalent non-CDB databases because a single patch applied to the CDB covers all contained PDBs at once, rather than requiring separate patch application and testing for each standalone database.
All PDBs within a CDB share the same Oracle Database software installation, so a single patch operation on the CDB simultaneously patches all PDBs - reducing patching cycles compared to patching each database individually.
Concept tested: Oracle multitenant CDB and PDB architecture shared resources and patching
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/introduction-to-the-multitenant-architecture.html
Topics
Community Discussion
No community discussion yet for this question.