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.
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)- A90% (35)
- C8% (3)
- E3% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.