Oracle Database Administration II — Question 140

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

Answer options

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

Correct answer: A, C, D

Explanation

Option A is correct because the Pre-Upgrade Information Tool script is indeed executed by DBUA to prepare for the upgrade. Option C is correct as it states that all pluggable databases are automatically upgraded during a container database upgrade. Option D is also accurate, as a full backup of the database is essential before proceeding with the upgrade to ensure data safety. Options B, E, and F are incorrect as they do not represent necessary conditions for the upgrade process.