1Z0-083 practice question 20 of 35

Choose the best. How do you configure a CDB for local undo mode?

Full set: 286 questions
Answer options
A:

A. 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.

B:

B. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

Correct answer
C:

C. 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.

D:

D. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

E:

E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

Correct Answer:
B. B. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
Explanation

To switch a multitenant container database (CDB) from the default shared undo mode to local undo mode, a specific procedure must be followed. The CDB instance must be shut down and then started in UPGRADE mode. While connected to the root container (CDB$ROOT), the ALTER DATABASE LOCAL UNDO ON; command is executed. After this command completes successfully, the CDB instance must be shut down and restarted for the change to take effect.

Why Incorrect

A. The command is executed in the root, not each PDB, and the database must be in UPGRADE mode, not restricted mode.
C. The ALTER DATABASE LOCAL UNDO ON command must be executed in the root container (CDB$ROOT), not in each individual PDB.
D. The correct mode for this operation is UPGRADE, not RESTRICTED. Restricted mode is for administrative tasks that do not involve database-wide structural changes like this.
E. This operation cannot be performed while the database is in READ ONLY mode, as it modifies the database's fundamental structure.

References

- Oracle Database Administrator's Guide, 19c, Chapter 35, "Managing Undo in a Multitenant Environment", Section: "Switching from Shared Undo Mode to Local Undo Mode". The guide explicitly outlines the steps: "Start up the CDB in upgrade mode. ... Execute the ALTER DATABASE LOCAL UNDO ON; statement. ... Restart the CDB."

Scroll to Top