Oracle Database Administration II — Question 51

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Answer options

• A. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
• B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
• C. A new PDB is automatically created when importing a non-CDB into a CDB.
• D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
• E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
• F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Correct answer: B, D

Explanation

Option B is correct because Oracle does attempt to convert conventional database users into local users when schemas are moved from a non-CDB to a PDB. Option D is also correct as Oracle tries to convert common users to conventional users when schemas are migrated from a PDB to a non-CDB. The other options are incorrect as they do not accurately describe the processes involved in data movement between non-CDBs and PDBs.