Oracle
1Z0-068 · Question #122
Which two statements are tuning recommendations for RAC database? (Choose two.)
The correct answer is D. Use Locally Managed Tablespaces with autoallocate. F. Use sequences with CACHE and NOORDER, if possible. See the full explanation below for the reasoning.
Question
Which two statements are tuning recommendations for RAC database? (Choose two.)
Options
- ASet PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
- BUse sequences with CACHE and ORDER, if possible.
- CUse Locally Managed Tablespaces with large uniform extent sizes.
- DUse Locally Managed Tablespaces with autoallocate.
- ESet PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
- FUse sequences with CACHE and NOORDER, if possible.
How the community answered
(27 responses)- A11% (3)
- C7% (2)
- D78% (21)
- E4% (1)
Community Discussion
No community discussion yet for this question.