Which three statements are true about unplugging a plug…

Which three statements are true about unplugging a pluggable database (PDB)?

Which three statements are true about unplugging a pluggable database (PDB)?

A.
A PDB must be in closed state before it can be unplugged.

B.
A PDB must have been opened at least once after creation.

C.
A PDB must be in MOUNT state before it can be unplugged.

D.
PDB data files are automatically removed from disk.

E.
An unplugged PDB can be plugged into the same or another container database (CDB).



Leave a Reply 6

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


engmohamin

engmohamin

A ,B ,E

le_admin

le_admin

A, C, E

A – You need to close PDB before unplugging
B – It is not true, You can unplug freshly created PDB
C – PDB is in MOUNTED state after closing
D – Unplugging does nothing to datafiles – drop pluggable database does
E – Yes You can do this

amsunhasav

amsunhasav

ABE
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13858

38.7.2 Unplugging a PDB
You must meet prerequsites when unplugging a PDB.

The following prerequisites must be met:

The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.

The PDB must have been opened at least once.

The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must be closed on all instances.

amsunhasav

amsunhasav

BCE, there is no Closed instance status. PDB have mount and open status.