Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 128 discussion

Actual exam question from Oracle's 1z0-062

Question #: 128
Topic #: 1

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 12c Releases 1 64-bit
Character set: WE8ISO8859P15
National character set: AL16UTF16
O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character set: AL32UTF8
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. Transportable database
B. Transportable tablespace
C. Data Pump full export / import
D. The DBMS_PDB package
E. RMAN

Show Suggested Answer

Suggested Answer: C 🗳️

by 5kong at March 14, 2020, 4:58 p.m.

Comments

Submit Cancel

Ray_gk

3 years, 2 months ago

I agree with C. This exam is based on 12cR1. In 12cR1, Oracle did not yet support differing charactersets in the same container database. However, future releases do support this so I believe in the case of future releases D would be correct.

upvoted 1 times

...

Ray520

3 years, 3 months ago

Reference: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=237882283796393&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1968706.1&_afrWindowMode=0&_adf.ctrl-state=9tgv5ju3b_4 In Oracle Database 12c, all pluggable databases (PDBs) in a container database (CDB) must have * the same Database character set (NLS_CHARACTERSET) or the NLS_CHARACTERSET need to be a (Plug-in compatible) binary subset of the CDB NLS_CHARACTERSET * the same National character set (NLS_NCHAR_CHARACTERSET) as the CDB's root container in order to be able to plug in.

upvoted 2 times

Ray520

3 years, 3 months ago

We can use DMU to convert the non-CDB characterset first and then mograte. Export/import does not have character set dependency. Answer is Export/import

upvoted 2 times

...

katetel

3 years, 11 months ago

finally, the answer is d

upvoted 3 times

...

PaoloBL

3 years, 11 months ago

D would be faster but 12.1 does not support pdb with character set different from cdb

upvoted 1 times

...

charan94

4 years, 4 months ago

D is correct answer. Since, most of the time the the non cdb will be online i.e pre tasks and will be offline only while plugging in to as pdb.

upvoted 3 times

...

dam101

4 years, 4 months ago

Answer: C - ref https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9537016000346410905

upvoted 3 times

...

Modasser

4 years, 6 months ago

Answer should be D coz: – If the non-CDB is version pre 12c or 12c you can still consider using DBMS_PDB package. – If the non-CDB is version 11.2.0.3 or later you can still consider using Transport Database. – If the non-CDB is version pre-11.2.0.3 you can still consider using transportable tablespaces.

upvoted 4 times

...

vineetarneja

5 years, 1 month ago

yes. the correct answer is D only. the size and characterset of the non-cdb doesn't matter while plugging it into a cdb.

upvoted 2 times

...

5kong

5 years, 4 months ago

Question #54

upvoted 2 times

NorthKorean

5 years, 4 months ago

Correct Answer: B * Overview, example: - Log into ncdb12c as sys - Get the database in a consistent state by shutting it down cleanly. - Open the database in read only mode - Run DBMS_PDB.DESCRIBE to create an XML file describing the database. - Shut down ncdb12c - Connect to target CDB (CDB2) - Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2) - Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2). - Access the PDB and run the noncdb_to_pdb.sql script. - Open the new PDB in read/write mode. * You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB. * Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.

upvoted 2 times

hggz

5 years, 4 months ago

From your answer D is correct: use DBMS_PDB package

upvoted 4 times

...

Patrick9230

5 years, 4 months ago

B is error . Transportable tablespace have two condition. Source and Target DB' Character Set,National Character Set must be same

upvoted 3 times

...

NorthKorean

5 years, 4 months ago

I just copied from #54

upvoted 1 times

...