Oracle Database Administration II — Question 127

How do you configure a CDB for local undo mode?

Answer options

• A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
• B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
• C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
• D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
• E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Correct answer: A

Explanation

The correct answer is A because it specifies opening the CDB instance in upgrade mode and executing the necessary command in CDB$ROOT to enable local undo, followed by a restart. The other options either involve incorrect modes or additional steps that are not required to configure local undo mode.