1Z0-060 · Question #212
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
The correct answer is A. The unplugged PDB can be plugged into the same multitenant container database (CDB). B. The unplugged PDB can be plugged into another CDB. F. The PDB must be closed. Unplugging a PDB requires the PDB to be closed, produces an XML manifest paired with existing data files that are left on disk, and the result can be plugged into the same or a different CDB.
Question
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
Options
- AThe unplugged PDB can be plugged into the same multitenant container database (CDB).
- BThe unplugged PDB can be plugged into another CDB.
- CThe PDB must be open in read-only mode.
- DThe PDB data files are automatically removed from disk.
- EThe unplugged PDB becomes a non-CDB.
- FThe PDB must be closed.
How the community answered
(31 responses)- A87% (27)
- C3% (1)
- D3% (1)
- E6% (2)
Why each option
Unplugging a PDB requires the PDB to be closed, produces an XML manifest paired with existing data files that are left on disk, and the result can be plugged into the same or a different CDB.
After unplugging, Oracle generates an XML descriptor file alongside the PDB's data files. This package can be used to re-plug the PDB into the original CDB provided no naming or compatibility conflicts exist.
The main purpose of the unplug operation is portability - the XML manifest and data files can be transported to any compatible CDB, enabling database consolidation, cloud migration, or version upgrades.
Incorrect - read-only mode is insufficient; the PDB must be fully CLOSED (status = MOUNTED or lower) before it can be unplugged.
Incorrect - Oracle does not remove data files when a PDB is unplugged; the files remain on disk so they can be referenced by the XML manifest during a future plug-in operation.
Incorrect - an unplugged PDB is not converted to a non-CDB; it retains its PDB structure (XML manifest plus data files) and can be plugged into any compatible CDB.
Oracle enforces that the PDB must be in CLOSED status before the UNPLUG INTO command is issued. Attempting to unplug a PDB that is open in any mode - including read-only - will result in an error.
Concept tested: PDB unplug prerequisites and behavior in Oracle CDB
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-2D225F97-9BFB-4B41-A0DE-B96FA4E63EF1
Topics
Community Discussion
No community discussion yet for this question.