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

Question

Options

• AAny Recovery Manager (RMAN) recovery catalog must be upgraded manually.
• BAfter a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new
• CTime zone files must be upgraded manually using the DBMS_DST PL/SQL package.
• DThe new extended data type capability must be enabled by running the utlrp.sql script
• EThe Oracle Application Express configuration should be updated after upgrading Oracle

• A
  84% (21)
• B
  12% (3)
• C
  4% (1)

Explanation

A is correct because DBUA does not automatically upgrade the RMAN recovery catalog - you must manually run UPGRADE CATALOG in RMAN after the database upgrade completes. D is correct because utlrp.sql must be run post-upgrade to recompile invalid PL/SQL/Java objects, which is necessary to make new capabilities like extended data types functional. E is correct because Oracle Application Express (APEX) has its own schema and metadata that DBUA does not migrate automatically - its configuration must be updated separately after the upgrade.

B is wrong because it describes a concern for manual upgrades, not DBUA - when using DBUA, Oracle Net configuration (including TNSNAMES entries) can be handled during the upgrade wizard, and service names typically remain unchanged. C is wrong because DBUA itself offers time zone file upgrade as part of the upgrade process, so it is not strictly a manual post-upgrade requirement - DBMS_DST is the tool used if you do it separately, but it's not forced post-DBUA.

Memory tip: Think "RMAN, recompile, APEX" - three things DBUA leaves for you to handle manually. If it's about an external catalog (RMAN), fixing broken objects (utlrp), or a separately-installed product (APEX), DBUA steps aside and you must act.

No community discussion yet for this question.