1Z0-062 · Question #181
Which three statements are true about the Pre-Upgrade Information Tool?
The correct answer is B. It writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table. C. It evaluates the dependencies of network utility packages. D. It identifies any deprecated and unsupported parameters. This question tests knowledge of what the Oracle Pre-Upgrade Information Tool (preupgrade.jar) does and does not do automatically before a database upgrade. The tool is diagnostic and script-generating, not self-executing.
Question
Which three statements are true about the Pre-Upgrade Information Tool?
Options
- AIt clears all user recycle bins in a database and releases their storage space.
- BIt writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table.
- CIt evaluates the dependencies of network utility packages.
- DIt identifies any deprecated and unsupported parameters.
- EIt generates fix-up scripts and automatically runs them to resolve issues that are flagged in the
How the community answered
(25 responses)- A4% (1)
- B88% (22)
- E8% (2)
Why each option
This question tests knowledge of what the Oracle Pre-Upgrade Information Tool (preupgrade.jar) does and does not do automatically before a database upgrade. The tool is diagnostic and script-generating, not self-executing.
The Pre-Upgrade Information Tool does not automatically purge user recycle bins - purging recycle bins may be recommended in its output, but the DBA must execute that action manually or via generated fix-up scripts.
The Pre-Upgrade Information Tool queries the database and writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table so the DBA can compare object validity before and after upgrade.
The tool evaluates dependencies of network utility packages such as UTL_FILE, UTL_TCP, UTL_HTTP, and UTL_SMTP to identify any access control list (ACL) or privilege issues that must be resolved before upgrading.
The tool checks initialization parameters in use against the new Oracle version and identifies any that are deprecated or no longer supported, prompting the DBA to update the parameter file accordingly.
The tool generates fix-up scripts (preupgrade_fixups.sql and postupgrade_fixups.sql) for identified issues, but it does not automatically execute them - the DBA must review and run them manually before or after the upgrade.
Concept tested: Oracle Pre-Upgrade Information Tool capabilities and limitations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-preupgrade-information-tool-for-oracle-database.html#GUID-C0F1B845-EF72-4EAA-B9A9-97CA7AF8AA03
Topics
Community Discussion
No community discussion yet for this question.