Oracle Database 12c: Installation and Administration — Question 88

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

Answer options

• A. Put all readonly tablespaces in read write mode
• B. Recompile all invalid objects
• C. Set the compatible parameter to 12.1.0.1
• D. Gather dictionary statistics
• E. Empty all user recycle bins

Correct answer: B, E

Explanation

The correct answers are B and E because recompiling invalid objects ensures that all database components are functional after the upgrade, while emptying user recycle bins helps prevent any issues related to unnecessary data during the upgrade. Options A, C, and D are not prerequisites for the upgrade process.