Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 618

Review Questions
1. In the Oracle 12 c multitenant architecture, what is a common use for Data Pump?
(Choose all that apply.)
A. To migrate a full non-CDB into a CDB
B. To load the contents of a PDB into another PDB
C. To load specific tables or schemas from a non-CDB into a PDB
D. To import a schema from a non-CDB into a PDB
E. All of the above
2. The DBMS_DATAPUMP PL/SQL package is used for which of the following activities?
A. Accepting parameters from expdb and importing content into CDB$ROOT
B. Confirming metadata validity between the CDB$ROOT and the local PDB
C. Direct path load of content into the CDB$ROOT
D. Accepting parameters from expdp and exporting content based on the parameters
3. When importing with Data Pump into a CDB and the target CDB does not have the
same common username as that of the export, what do you need to do to make sure
the import works? (Choose all that apply.)
A. Create the common user in the target CDB with the same privileges as it had in
the source.
B. Use the SYS schema to complete the import.
C. Remap the common user schema from the target to a local user in the source.
D. Remap the common user schema from the source to a local user in the target.
E. None of the above.
4. To import using Data Pump into the PDB1 container, which of the following must be true?
A. You must define a directory object within PDB1 and use that as the DUMPFILE
directory.
B. You must define a directory object within CDB$ROOT and use that as the DUMPFILE
directory.
C. You do not define a directory object within PDB1 ; simply use a DUMPFILE directory
on the server.
D. None of the above.