1Z0-062 · Question #183
Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c
The correct answer is D. Gather dictionary statistics. E. Empty all user recycle bins.. Before starting an Oracle Database 12c upgrade, gathering dictionary statistics and emptying recycle bins are required pre-upgrade steps to ensure a smooth and accurate upgrade process.
Question
Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c
Options
- APut all readonly tablespaces in read write mode.
- BRecompile all invalid objects
- CSet the compatible parameter to 12 1 0 1
- DGather dictionary statistics.
- EEmpty all user recycle bins.
How the community answered
(41 responses)- A2% (1)
- B2% (1)
- C2% (1)
- D93% (38)
Why each option
Before starting an Oracle Database 12c upgrade, gathering dictionary statistics and emptying recycle bins are required pre-upgrade steps to ensure a smooth and accurate upgrade process.
Read-only tablespaces do not need to be switched to read-write mode before the upgrade; Oracle can upgrade with read-only tablespaces in place.
Recompiling invalid objects is a post-upgrade task, performed after the upgrade completes to restore objects that became invalid during the process.
The COMPATIBLE parameter must not be set to 12.1.0.1 before the upgrade - it is changed after the upgrade is complete and verified, as changing it pre-upgrade would be invalid and unsupported.
Gathering dictionary statistics before the upgrade ensures the optimizer has accurate statistics on data dictionary tables, which the upgrade scripts rely on for efficient execution and correct operation of internal queries during the upgrade process.
Emptying all user recycle bins removes dropped objects that could interfere with the upgrade scripts and prevents accumulation of invalid metadata that the upgrade process would otherwise have to handle, which is explicitly listed as a required pre-upgrade task by Oracle.
Concept tested: Oracle Database 12c pre-upgrade preparation steps
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/tasks-prepare-upgrade-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.