Oracle Database 12c: RAC Administration — Question 40

Which three statements are tuning recommendations for RAC database? (Choose three.)

Answer options

• A. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
• B. Use sequences with CACHE and ORDER, if possible.
• C. Use Locally Managed Tablespaces with large uniform extent sizes.
• D. Use Locally Managed Tablespaces with autoallocate.
• E. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
• F. Use sequences with CACHE and NOORDER, if possible.

Correct answer: A, C, F

Explanation

The correct answers are A, C, and F because they follow best practices for enhancing performance in a RAC database environment. Option A optimizes parallel query execution, option C promotes efficient space management, and option F is preferred for reducing contention. Options B, D, and E do not align as closely with the recommended practices for tuning RAC databases.