Oracle Exam 1Z0-083 Topic 8 Question 105 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 105
Topic #: 8

Choose the best answer. 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: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED --------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

AIt fails because PDB$SEED is in MIGRATE state.

BOnly CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

COnly CDB$ROOT, PDB$SEED, and PDB2 are upgraded.

DIt fails because PDB2 is not in UPGRADE state.

ECDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

FOnly CDB$ROOT and PDB$SEED are upgraded.

Show Suggested Answer

Suggested Answer: D

by Eliz at Sep 19, 2024, 06:37 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Barney

2 months ago

Haha, I bet the Oracle engineers who wrote this question were having a field day coming up with all these different scenarios. Let's see if I can crack the code!

upvoted 0 times

Laurene

1 months ago

User 3: I'm going with D) It fails because PDB2 is not in UPGRADE state.

upvoted 0 times

...

Caitlin

1 months ago

User 2: No, I believe it's B) Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

upvoted 0 times

...

Benedict

1 months ago

User 1: I think the answer is E) CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

upvoted 0 times

...

Hildred

2 months ago

Hmm, this is a tricky one. I'm leaning towards B, since the question mentions that only PDB1 is explicitly opened for upgrade, so the other PDBs might not be upgraded.

upvoted 0 times

Cary

17 days ago

No, I don't think so. B makes more sense based on the information given.

upvoted 0 times

...

Audra

20 days ago

But what about C? Could that be a possibility?

upvoted 0 times

...

Mayra

2 months ago

I agree, B seems like the most logical choice.

upvoted 0 times

...

Peter

2 months ago

I think B is the correct answer.

upvoted 0 times

...

Rodrigo

2 months ago

D seems more likely to me. The question says PDB2 is in the MOUNTED state, not the UPGRADE state, so the upgrade command for PDB2 should fail.

upvoted 0 times

...

Brinda

2 months ago

I think the correct answer is E. The question states that all preupgrade tasks have been successfully performed, so PDB2 should be in the UPGRADE state. The command to upgrade PDB2 is executed, so all the PDBs should be upgraded.

upvoted 0 times