Oracle Database Administration 2019 Certified Professional — Question 55

Which three statements are true about undo management in a RAC environment? (Choose three.)

Answer options

• A. You can dynamically assign a newly created undo tablespace to an instance.
• B. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
• C. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
• D. A mixture of automatic undo management and manual undo management is supported within a RAC database.
• E. It is necessary to assign a specific undo tablespace to a specific instance.

Correct answer: A, B, C

Explanation

Answer A is correct because you can dynamically assign a new undo tablespace in a RAC environment. Answer B is also correct since enabling OMF allows automatic creation of undo tablespaces in a policy-managed RAC database. Answer C is true as well because instance recovery can access the undo tablespace of a failed instance. Answers D and E are incorrect because RAC databases do not require a specific undo tablespace for each instance, and a mixture of management types is not supported.