Oracle Database Administration II — Question 29

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

Answer options

• A. It recompiles all stored PL/SQL code by using utlrp.sql.
• B. It empties the RECYCLE BIN.
• C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D. It sets all user tablespaces to ג€read-onlyג€ before starting the upgrade.
• E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F. It increases tablespace size, if required, to meet upgrade requirements.

Correct answer: B, C, F

Explanation

The correct actions performed by DBUA include emptying the RECYCLE BIN (B), conducting prerequisite checks (C), and increasing tablespace size if needed (F). Options A, D, and E are not standard actions taken by DBUA during the upgrade process.