ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam
Go to Exam

Exam 1z0-083 topic 1 question 109 discussion

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

Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:

What is the outcome?

  • A. It fails because PDB$SEED is in MIGRATE state.
  • B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
  • C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
  • D. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
  • E. Only CDB$ROOT and PDB$SEED are upgraded.
  • F. It fails because PDB2 is not in UPGRADE state.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by RinD at May 7, 2021, 7:55 a.m.

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
Submit Cancel
saserdi
Highly Voted 2 years, 7 months ago
C https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
upvoted 5 times
...
_gio_
Most Recent 7 months ago
Selected Answer: C
C but I think there is a error in the question: PDB1 is in mount so upgrade will fail. if the error is "-C" instead of "-c", answer F would be correct
upvoted 1 times
...
vkra
11 months, 1 week ago
Selected Answer: C
C : https://docs.oracle.com/en/database/oracle/oracle-database/19/spupu/unplugging-plugging-and-upgrading-pdb-new-cdb.pdf. See section Upgrading the Earlier Release PDB to the Later Release. and for the parameters: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
upvoted 1 times
...
hilaire
1 year ago
C is correct -C exclude and -c include
upvoted 3 times
...
Marco_M
2 years, 8 months ago
For me C is correct. https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
upvoted 2 times
...
Aldrid
2 years, 8 months ago
C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded. CDB$ROOT - In Upgrade MOde PDB$SEED - in Upgrade Mode PDB1 - In Upgrade Mode (Alter .. Open Upgrade) PDB2 - Excluded A - Incorrect When a PDB is in open migrate mode, you can run database upgrade scripts on the PDB F-Incorrect -it's excluded.
upvoted 3 times
mporislav
2 years, 8 months ago
C You are correct so does RinD
upvoted 1 times
...
...
mporislav
2 years, 9 months ago
A procedure (-c exclude PDB2): SQL> startup upgrade; SQL> alter pluggable database all open upgrade; run parallel upgrade utility
upvoted 1 times
RinD
2 years, 8 months ago
I rechecked and found that: -c include -C exclude So in this case it exclude PDB2 as you said. So I think C correct: When a PDB is in open migrate mode, you can run database upgrade scripts on the PDB.
upvoted 1 times
...
...
RinD
2 years, 9 months ago
F correct https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD
upvoted 2 times
ErikJanssen
1 year ago
I think C is correct; You can upgrade individual PDBs by putting one in upgrade mode individually. https://docs.oracle.com/en/database/oracle/oracle-database/19/spupu/unplugging-plugging-and-upgrading-pdb-new-cdb.pdf. See section Upgrading the Earlier Release PDB to the Later Release.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago