1Z0-083 practice question 19 of 35
Choose the best. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable…
Full set: 286 questionsChoose the best. 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?
The parallel upgrade utility, catctl.pl, requires that any Pluggable Database (PDB) it is instructed to upgrade must first be opened in UPGRADE mode. The command sequence shows that PDB1 was correctly placed in UPGRADE mode, but PDB2 was left in the MOUNTED state. The subsequent catctl.pl -C 'PDB2' command specifically targets PDB2 for an upgrade. Because PDB2 is not in the required UPGRADE state, the catctl.pl script will fail, as its prerequisite check for the target PDB will not pass.
A. PDB$SEED must be in MIGRATE state for a CDB upgrade to proceed; this is the correct and expected state.
B. The command catctl.pl -C 'PDB2' explicitly targets PDB2, not PDB1. Therefore, the script would not attempt to upgrade PDB1.
C. This would be the outcome if PDB2 had been correctly opened in UPGRADE mode prior to running catctl.pl.
E. The command only targets PDB2 for the PDB upgrade portion. It would not upgrade PDB1, and the entire operation fails due to PDB2's state.
F. The script was explicitly invoked to process PDB2. It will fail on that PDB rather than skipping it and only upgrading the root and seed.
Oracle Database Upgrade Guide, 18c, Chapter 4, "Upgrading a Multitenant Database with catctl.pl". The section "Running the Parallel Upgrade Utility on a CDB" states: "For each PDB that you want to upgrade, you must also open the PDB in UPGRADE mode: SQL> ALTER PLUGGABLE DATABASE pdbname OPEN UPGRADE;". This prerequisite was not met for PDB2.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
