Exam 1z0-062 topic 1 question 180 discussion

Actual exam question from Oracle's 1z0-062

Question #: 180
Topic #: 1

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?

A. Run catuppst.sql to perform revalidation actions
B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
C. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.
D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Show Suggested Answer

Suggested Answer: D 🗳️

by yosiw96816 at Sept. 2, 2020, 9:54 a.m.

Comments

Submit Cancel

yosiw96816

4 years, 9 months ago

Why not B? https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60103

upvoted 2 times

jackymak

3 years, 3 months ago

According to doc your provided:"Use utluiobj.sql to display only those objects which are newly invalid because of the upgrade process" It is "display", not fixing the invalid object.

upvoted 1 times

...