Which three are valid statements?

You are preparing to create a RAC cluster. You review the RAC requirements for UNDO
tablespaces. Which three are valid statements? (Choose three.

You are preparing to create a RAC cluster. You review the RAC requirements for UNDO
tablespaces. Which three are valid statements? (Choose three.

A.
You cannot assign a specific UNDO tablespace to a specific instance.

B.
It is not necessary to assign a specific UNDO tablespace to a specific instance.

C.
ALTER SYSTEM SET UNDO_TABLESPACE=undotbs3 SID=’RDBD01′; is correct.

D.
ALTER DATABASE SET UNDO_TABLEPACE=undotbs3 SID=’RDBD01′; is correct.

E.
If no UNDO tablespace is available when the instance starts, the instance stores undo records
in the SYSTEM rollback segments.



Leave a Reply 0

Your email address will not be published. Required fields are marked *