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 *