nerdexam
Oracle

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.

New Features for Database Infrastructure and Architecture

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)
  • A
    5% (3)
  • B
    91% (58)
  • C
    2% (1)
  • D
    3% (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.

APluggable databases in the same container database (CDB) each have their own buffer cache

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.

BPluggable databases can make database consolidation easierCorrect

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.

CAll administration tasks must be done to each pluggable database.

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.

DPluggable databases increase patching time.

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.

EPluggable databases are patched togetherCorrect

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

#multitenant CDB#pluggable databases#database consolidation#PDB patching

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice