1z0-063 Exam QuestionsBrowse all questions from this exam

1z0-063 Exam - Question 9


You want to export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB) CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.

Examine the list of possible steps required to perform the task:

1. Create a PDB named emp_pdb1.

2. Export the hr_pdb1 PDB by using the full clause.

3. Open the emp_pdb1 PDB.

4. Mount the emp_pdb1 PDB.

5. Synchronize the emp_pdb1 PDB in restricted mode.

6. Copy the dump file to the Data Pump directory.

7. Create a Data Pump directory in the emp_pdb1 PDB.

8. Import data into emp_pdb1 with the full and remap clauses.

9. Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.

Identify the required steps in the correct order.

Show Answer
Correct Answer: A

To successfully export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB) CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB, the following steps must be followed in sequence: 1) Export hr_pdb1 using the full clause to export all its data and configurations. 2) Create the new PDB emp_pdb1 which will host the imported data. 3) Open emp_pdb1 to get it ready for data import. 4) Create a Data Pump directory in emp_pdb1 to store the dump file. 5) Copy the dump file to the Data Pump directory created. 6) Import the data into emp_pdb1 using the full and remap clauses to ensure the data is correctly mapped into the new PDB. These steps ensure that all necessary elements, excluding tablespace creation which is handled during the import using the full clause, are covered.

Discussion

3 comments
Sign in to comment
rcgenilo27
Jul 16, 2020

ans: A

Sugar
Jul 16, 2020

C is correct

Simon22
May 10, 2021

A is correct as every option starting with 2. Export the hr_pdb1 PDB by using the full clause. oracle documentation " A full export is specified using the FULL parameter. In a full database export, the entire database is unloaded " Thus no tablespace creation is needed

Simon22
May 10, 2021

A is correct as every option starting with 2. Export the hr_pdb1 PDB by using the full clause. oracle documentation " A full export is specified using the FULL parameter. In a full database export, the entire database is unloaded " Thus no tablespace creation is needed

hilaire
Jul 9, 2021

A is correct

Abby_
Jan 11, 2022

A is correct going by the steps listed in this link: https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/OU/MigratingToDBaaS/ExportandImportMigration/ExportandImportMigration.html#section1