Oracle Database Administration II — Question 171

Examine this configuration:

1. CDB1 is an Oracle container database from an older release.
2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.

A priority list UpgrdList has these entries:

1, pdb2
2, pdb1, pdb3

You execute this command:

$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList

In which order will the upgrade occur?

Answer options

• A. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
• B. CDB$ROOT, PDB2, PDB1, and PDB3
• C. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
• D. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
• E. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

Correct answer: C

Explanation

The upgrade will start with CDB$ROOT, followed by PDB$SEED, and then PDB2 due to its higher priority in the list. After PDB2, the upgrade will proceed with PDB1 and PDB3, as they are listed next, and PDB4 will be last because it is not mentioned in the upgrade list.