Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-083 Topic 8 Question 105 Discussion

Actual exam question for Oracle's 1Z0-083 exam
Question #: 105
Topic #: 8
[All 1Z0-083 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

Hildred
5 days 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
...
Rodrigo
7 days 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
16 days 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
...
Ruthann
18 days ago
Hmm, I see your point. But I still think D is the right answer because PDB2 needs to be in UPGRADE state.
upvoted 0 times
...
Karma
21 days ago
I disagree, I believe the correct answer is E) CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
upvoted 0 times
...
Ruthann
22 days ago
I think the answer is D) It fails because PDB2 is not in UPGRADE state.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77