Which three statements are true about the Pre-Upgrade Information Tool?
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 portupgrade_fixups.sql script is created to address issues that can be fixed after a database has
been upgraded.
Explanation:
https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracledatabase.htm#UPGRD-GUID-C0219AF1-AD43-4097-B358-E53E48958647
The correct answers should be BCF.
– https://docs.oracle.com/database/121/UPGRD/preup.htm#UPGRD52880
The correct answers are BCF.
– https://docs.oracle.com/database/121/UPGRD/preup.htm#UPGRD52880
I don’t think preupgrade_fixups.sql is run automatically (not E).
I would select BCF.
https://oracle-base.com/articles/12c/upgrading-to-12c#manual-upgrades
BCF
The correct answers should be B, C and F.