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

Question

Options

• AAfter the change, only a common user with the required privilege can create an undo tablespace
• BAny new PDB and existing PDBs are automatically configured to use the default undo tablespace
• CAfter the change, only one undo tablespace can exist in CDB$ROOT.
• DAfter the change, any user with the required privilege can create an undo tablespace in the PDBs.
• EUndo tablespaces existing in PDBs must be dropped before the change.
• FAfter the change, each existing PDB has to be reopened for the new undo mode to take effect.

• A
  71% (42)
• B
  8% (5)
• C
  3% (2)
• D
  2% (1)
• E
  15% (9)

Explanation

A is correct, in shared UNDO mode, UNDO can exist in the CDB only. B is wrong, because PDBs must be reopened to recognize the central UNDO C is wrong, because as the database is RAC and enabled with LOCAL UNDO, you need to assign specific Undo tablespace to each PDB on node-1 & node-2 by executing below alter system set undo_tablespace=UNDOTBS1 container=current sid='DBCDB1' scope=spfile; >>>> sid=First Instance alter system set undo_tablespace=UNDOTBS2 container=current sid='DBCDB2' scope=spfile; >>>> sid=Second Instance D is wrong, becuase as long as LOCAL UNDO used you cant create UNDO in PDB E is wrong, PDB UNDO tablespaces should be dropped after the change. F is correct, when you change the undo mode of a CDB, the new undo mode applies to an individual container the first time the container is opened after the change.

No community discussion yet for this question.