Oracle Database 12c: Installation and Administration — Question 4

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

Answer options

• A. It generates a script to recompile invalid objects post-upgrade.
• B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.
• C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
• D. It checks for required tablespaces and if they are not available, creates them automatically.
• E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.
• F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

Correct answer: A, C, E

Explanation

The correct answers A, C, and E accurately describe the functions of the Pre-Upgrade Information Tool. A confirms that it creates a script for recompiling invalid objects, C notes the creation of a log file capturing the tool's output, and E states that the preupgrade_fixups.sql script runs automatically to address issues. Options B, D, and F are incorrect as they misrepresent the tool's functionalities, such as creating tablespaces automatically or addressing issues post-upgrade.