Exam 1z0-083 All QuestionsBrowse all questions from this exam
Question 172

Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three.)

    Correct Answer: A, B, C

    After upgrading an Oracle database using Database Upgrade Assistant (DBUA), it is necessary to update the configuration of Oracle Application Express (APEX) as there might be dependencies or new features in the upgraded database version. Also, time zone files must be upgraded manually using the DBMS_DST PL/SQL package as part of ensuring that the database handles time zones correctly in the new environment. Additionally, any Recovery Manager (RMAN) recovery catalog must be upgraded manually to ensure its compatibility with the new database version and to be able to perform appropriate recovery operations.

Discussion
ilputtoOptions: ACE

Oracle Database 12c Release 2 (12.2) DBUA : Understanding New Changes / Features (Doc ID 2171985.1)

vkra

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-F929338D-48EE-434F-A5F9-A9E7CD61B17F

antonicaOptions: BCE

BCE, i am in disagree with A, "Drop Earlier Release Oracle APEX To avoid invalid objects, drop Oracle APEX releases earlier than Application Express (APEX) 19.1." B is a better answer "Upgrading the Time Zone File Version After Upgrading Oracle Database If the AutoUpgrade preupgrade report instructs you to upgrade the time zone files after completing the database upgrade, and you do not set AutoUpgrade to complete this task for you, then use any of the supported methods to upgrade the time zone file."

_gio_Options: ACE

I agree with ACE

haaris786

Agree with ACE