1Z0-083 practice question 4 of 35

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

Full set: 286 questions
Answer options
A: DBUA must be launched from the target Oracle Home. Correct answer
B: Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
C: A whole database backup must exist before upgrade.
D: The Pre-Upgrade Information Tool script is executed by DBUA. Correct answer
E: All pluggable databases are automatically upgraded as part of a container database upgrade. Correct answer
F: The database must be opened in read-only mode.
Correct Answer:
A. DBUA must be launched from the target Oracle Home.; D. The Pre-Upgrade Information Tool script is executed by DBUA.; E. All pluggable databases are automatically upgraded as part of a container database upgrade.
Explanation

The Database Upgrade Assistant (DBUA) is a graphical tool for upgrading Oracle databases. It must be run from the Oracle Home of the target version (A) to use the new binaries for the upgrade process. A key feature of DBUA is its automation of pre-upgrade steps, including the execution of the Pre-Upgrade Information Tool (D), which checks the database for readiness. When upgrading a multitenant container database (CDB), DBUA automatically upgrades all of its associated pluggable databases (PDBs) as part of the single CDB upgrade operation (E). This ensures consistency across the entire container architecture.

Why Incorrect

B: DBUA is designed to upgrade one database at a time per session. To upgrade multiple databases, you must run separate DBUA instances. C: DBUA strongly recommends a backup and provides an option to create one, but it does not strictly require one to exist before starting the tool. F: The database is placed in UPGRADE mode during the upgrade process, not read-only mode, to allow the necessary dictionary changes.

References

1. Oracle Database Upgrade Guide 19c, Chapter 4, "Upgrading with Database Upgrade Assistant (DBUA)". Section "Starting DBUA" states: "Run DBUA from the target Oracle home."

2. Oracle Database Upgrade Guide 19c, Chapter 4, "About the Pre-Upgrade Information Tool". It states DBUA runs the pre-upgrade checks automatically.

3. Oracle Database Multitenant Administrator’s Guide 19c, Chapter 10, "Upgrading a CDB". Section "About Upgrading a CDB" states: "When you upgrade a CDB, you upgrade the root, the seed, and all of the PDBs."

Scroll to Top