Oracle Database Administration II — Question 159

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

Answer options

• A. The Oracle Application Express configuration should be updated after upgrading Oracle Database.
• B. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
• C. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
• D. The new extended data type capability must be enabled by running the utlrp.sql script.
• E. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

Correct answer: A, C, E

Explanation

Option A is correct because updating the Oracle Application Express configuration is a necessary step after the database upgrade. Option C is also correct, as any existing RMAN recovery catalog requires a manual upgrade. Option E is true as well, since TNSNAMES.ORA must be adjusted to point to the new ORACLE_HOME. Options B and D are incorrect; upgrading time zone files is generally not a manual process, and the activation of extended data types does not require running the utlrp.sql script.