Which three statements are true concerning unplugging a pluggable database (PDB)?
A.
The PDB must be open in read only mode.
B.
The PDB must be dosed.
C.
The unplugged PDB becomes a non-CDB.
D.
The unplugged PDB can be plugged into the same multitenant container database (CDB)
E.
The unplugged PDB can be plugged into another CDB.
F.
The PDB data files are automatically removed from disk.
Explanation:
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode
information in an endianness-sensitive way. There is no supported way to handle the conversion
of such columns automatically. This means, quite simply, that an unplugged PDB cannot be
moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most
effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles
can remain in place.
Oracle White Paper, Oracle Multitenant
B,D&E
B D E
BDE
B, D and E
A, D and E, have look.
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
5 QA READ WRITE NO
SQL> CREATE PLUGGABLE DATABASE QA_PDB FROM PDB STORAGE UNLIMITED FILE_NAME_CONVERT=NONE;
CREATE PLUGGABLE DATABASE QA_PDB FROM PDB STORAGE UNLIMITED FILE_NAME_CONVERT=NONE
*
ERROR at line 1:
ORA-65036: pluggable database PDB not open in required mode
SQL> ALTER PLUGGABLE DATABASE PDB OPEN READ ONLY;
Pluggable database altered.
SQL> CREATE PLUGGABLE DATABASE QA_PDB FROM PDB STORAGE UNLIMITED FILE_NAME_CONVERT=NONE;
Pluggable database created.
B,D,E
From this tutorial http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/pdb_unplug_plug.html
B, To unplug a PDB you must before close it
D, and E You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB