Oracle Database 12c: Installation and Administration — Question 66

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

Answer options

• A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
• B. It automatically makes necessary changes to Oracle environment variables.
• C. It automatically enables unified auditing in the upgraded database.
• D. It automatically adds new data files if there is not enough disk space to grow.

Correct answer: D

Explanation

The correct answer is D because the DBUA is designed to handle disk space limitations by automatically adding new data files as needed. Option A is incorrect as the DBUA does not terminate due to the SYSTEM tablespace's autoextensibility. Options B and C are also incorrect since the DBUA does not modify Oracle environment variables or enable unified auditing automatically during the upgrade process.