Which two statements are true concerning dropping a plu…

Which two statements are true concerning dropping a pluggable database (PDB)?

Which two statements are true concerning dropping a pluggable database (PDB)?

A.
The PDB must be open in read-only mode.

B.
The PDB must be in mount state.

C.
The PDB must be unplugged.

D.
The PDB data files are always removed from disk.

E.
A dropped PDB can never be plugged back into a multitenant container database (CDB).

Explanation:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

kas

kas

Again here some questions..

B & C make sense because both is a possible solution (nonetheless the question is incomplete and “must” in both answers basically eliminates the other option.

But regarding option E:
How could you plugin in a dropped PDB again? There is basically no way to plugin in the exact dropped database.

You can create an xml manifest before the drop and create a new pdb with the manifest and datafiles.

Or you could backup into an Aux DB and plug the PDB out of there and into your CDB.

BUT: it will never be the dropped PDB which will be plugged “back” in a CDB, because that PDB is dropped aka not existent anymore.

Any thoughts on that one?

Reply