nerdexam
Oracle

1Z0-067 · Question #117

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…

The correct answer is A. 2, 1, 3, 7, 6, and 8. Because the step 2 says that you perfom an expdp with the full clause and you dont need to create the tablespaces when you perform the impdp. FULL=yes will export tablespace definitions. So no need step 9. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

New Features for Database Infrastructure and Architecture

Question

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.

Options

  • A2, 1, 3, 7, 6, and 8
  • B2, 1, 4, 5, 3, 7, 6, 9, and 8
  • C2, 1, 3, 7, 6, 9, and 8
  • D2, 1, 3, 5, 7, 6, and 8

How the community answered

(30 responses)
  • A
    70% (21)
  • B
    10% (3)
  • C
    17% (5)
  • D
    3% (1)

Explanation

Because the step 2 says that you perfom an expdp with the full clause and you dont need to create the tablespaces when you perform the impdp. FULL=yes will export tablespace definitions. So no need step 9. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

Topics

#PDB migration#multitenant CDB#Data Pump#PDB import export

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice