nerdexam
Oracle

1Z0-060 · Question #206

Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB? (Choose three.)

The correct answer is A. Enterprise Manager Cloud Control B. SQL Developer D. Database Configuration Assistant (DBCA). Three tools support adding a new PDB to an existing CDB: DBCA, SQL Developer, and Enterprise Manager Cloud Control. DBUA handles version upgrades and OUI installs software binaries, so neither can add PDBs.

New Features for Database Infrastructure and Architecture

Question

Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB? (Choose three.)

Options

  • AEnterprise Manager Cloud Control
  • BSQL Developer
  • CDatabase Upgrade Assistant (DBUA)
  • DDatabase Configuration Assistant (DBCA)
  • EOracle Universal Installer (OUI)

How the community answered

(39 responses)
  • A
    90% (35)
  • C
    8% (3)
  • E
    3% (1)

Why each option

Three tools support adding a new PDB to an existing CDB: DBCA, SQL Developer, and Enterprise Manager Cloud Control. DBUA handles version upgrades and OUI installs software binaries, so neither can add PDBs.

AEnterprise Manager Cloud ControlCorrect

Enterprise Manager Cloud Control provides a full graphical database administration interface that includes workflows for creating, cloning, and plugging in PDBs to an existing CDB.

BSQL DeveloperCorrect

SQL Developer includes a DBA panel that supports multitenant operations such as creating new PDBs, cloning existing ones, and plugging unplugged PDBs into a CDB.

CDatabase Upgrade Assistant (DBUA)

Database Upgrade Assistant (DBUA) is designed solely to upgrade an existing Oracle database to a newer version and has no functionality for creating or plugging in PDBs.

DDatabase Configuration Assistant (DBCA)Correct

Database Configuration Assistant (DBCA) is the primary Oracle configuration tool and explicitly supports adding a new PDB to an existing CDB through its interactive and silent-mode workflows.

EOracle Universal Installer (OUI)

Oracle Universal Installer (OUI) installs Oracle Database software onto the operating system and does not perform any database configuration, creation, or PDB management tasks.

Concept tested: Tools for adding pluggable databases to a CDB

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/multi/creating-and-removing-pdbs-with-sql-plus.html

Topics

#pluggable database#CDB administration#DBCA#PDB provisioning tools

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice