Which two methods can be used to add an Oracle 11g data…

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as
a pluggable database (PDB)?

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as
a pluggable database (PDB)?

A.
Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

B.
Use the create database … enable pluggable database statement to create a PDB by copying data files
from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

C.
Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle
11g database into the newly created PDB.

D.
Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import
data from the Oracle 11g database to the newly created PDB.

E.
Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the
database as a new PDB into the CDB.



Leave a Reply 4

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


MS

MS

ANS C,E

B – cannot be the answer. You need to copy the data files if you are using transportable tablespace is used. No word mentioned about transportable tablespace

muhaha03

muhaha03

D,E
” You can use full transportable export/import to migrate from a non-CDB database into a PDB, from one PDB to another PDB, or from a PDB to a non-CDB.”
That’s why C is barely correct.