exam questions

Exam 1z0-063 All Questions

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

Exam 1z0-063 topic 1 question 36 discussion

Actual exam question from Oracle's 1z0-063
Question #: 36
Topic #: 1
[All 1z0-063 Questions]

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

  • A. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB. B. Use the CREATE DATABASE ... ENABLE PLUGGABLE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly DATABASE created PDB.
  • B. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
  • C. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
  • D. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
smokeystone
Highly Voted 5 years, 1 month ago
B and D
upvoted 5 times
...
arbol1
Most Recent 2 years, 1 month ago
There are two B. B. Use the CREATE DATABASE ... ENABLE PLUGGABLE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly DATABASE created PDB. and B. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
upvoted 1 times
...
hilaire
3 years, 6 months ago
BD correct Network link dont support parallel https://docs.oracle.com/database/121/SUTIL/GUID-0871E56B-07EB-43B3-91DA-D1F457CF6182.htm#SUTIL919
upvoted 1 times
hilaire
3 years, 5 months ago
pls forget this
upvoted 1 times
...
...
Simon22
3 years, 8 months ago
C not possible. To use network link the source database must be version is 12.1 or later. B in version 11. D possbile
upvoted 1 times
hilaire
3 years, 5 months ago
When operating across a network link, Data Pump requires that the source and target databases differ by no more than two versions. For example, if one database is Oracle Database 12c, then the other database must be 12c, 11g, or 10g. Note that Data Pump checks only the major version number (for example, 10g,11g, 12c), not specific release numbers (for example, 12.1,10.1, 10.2, 11.1, or 11.2).
upvoted 2 times
...
...
NorthKorean
4 years, 9 months ago
Isn't A B?
upvoted 3 times
NorthKorean
4 years, 9 months ago
Sorry B, C
upvoted 4 times
Sugar
4 years, 8 months ago
Should be B and C. A is not correct because export and import via data pump is the right way to move out data files
upvoted 2 times
...
...
...
Kobaltblue
5 years, 1 month ago
B AND ???
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago