Oracle Discussions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Go to Exam

Exam 1z0-062 topic 1 question 196 discussion

Actual exam question from Oracle's 1z0-062

Question #: 196
Topic #: 1

[All 1z0-062 Questions]

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

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.

Show Suggested Answer

Suggested Answer: ACE 🗳️
References -
https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracle-database.htm#UPGRD-GUID-C0219AF1-AD43-4097-
B358-E53E48958647

by rdnkrkmz at Jan. 18, 2019, 7:58 a.m.

Comments

Submit Cancel

Sugar

Highly Voted 5 years, 1 month ago

Khan is correct. BCF.

upvoted 9 times

...

Correct is BCF. The utlrp.sql is used to compile invalid objects (not specifically generated by the pre-upgrade tool) The pre_upgrade_fixups is not executed automatically but can be run manually. See ref: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgrade-information-tool-for-oracle-database.html#GUID-0C496815-1826-4E28-8437-36FA549000F9

upvoted 9 times

...

Ray520

Most Recent 2 years, 4 months ago

Selected Answer: BCF

The Pre-Upgrade Information Tool (preupgrade.jar) creates the following files: -A log file (preupgrade.log):The log file contains the output of the Pre-Upgrade Information Tool. -The pre-upgrade fixups: preupgrade_fixups.sql -The post-upgrade fixups:postupgrade_fixups.sql The preupgrade tool itself does not make changes to your database to correct errors. However, it does generate scripts that you can use to correct identified errors.

upvoted 1 times

...

duMaurier

3 years ago

Selected Answer: BCF

BCF running preupgrd.sql against the database being upgraded will generate 3 files preupgrade.log preupgrade_fixups.sql postupgrade_fixups.sql

upvoted 1 times

...

Clozoerie

3 years, 4 months ago

BCF too

upvoted 2 times

...

khan

5 years, 8 months ago

Answer BCF – https://docs.oracle.com/database/121/UPGRD/preup.htm#UPGRD52880

upvoted 6 times

...

rdnkrkmz

5 years, 11 months ago

I think the correct answer should be: ABC (not E, but B.) Because pre_up_fix.sql is run by hand.

upvoted 3 times

...