Oracle Database Administration II — Question 27

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

Answer options

• A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
• C. After the change, only one undo tablespace can exist in CDB$ROOT.
• D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• E. Undo tablespaces existing in PDBs must be dropped before the change.
• F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Correct answer: A, B

Explanation

The correct answers are A and B because when LOCAL_UNDO_ENABLED is set to false, only a common user with the required privileges can create an undo tablespace in CDB&ROOT, and all PDBs will default to using the undo tablespace defined in CDB$ROOT. Options C, D, E, and F are incorrect because the setting does not limit the number of undo tablespaces in CDB$ROOT, allows PDBs to use their own undo tablespaces, does not require existing undo tablespaces to be dropped, and does not necessitate reopening each PDB for the change to take effect.