Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 109 discussion

Actual exam question from Oracle's 1z0-083

Question #: 109
Topic #: 1

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

Suggested Answer: E 🗳️

by RinD at May 7, 2021, 7:55 a.m.

Comments

Submit Cancel

saserdi

Highly Voted 2 years, 11 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 10 months, 3 weeks 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

1 year, 3 months 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, 4 months ago

C is correct -C exclude and -c include

upvoted 3 times

...

Marco_M

3 years 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

3 years 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 4 times

mporislav

3 years ago

C You are correct so does RinD

upvoted 1 times

...

mporislav

3 years ago

A procedure (-c exclude PDB2): SQL> startup upgrade; SQL> alter pluggable database all open upgrade; run parallel upgrade utility

upvoted 1 times

RinD

3 years 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

3 years 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, 4 months 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

...