Which two statements are tuning recommendations for RAC database? (Choose two.)
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.
I think
E , E
E and F
Correct: E, F
E is a tunning recommendation for any kind of Database RAC and Single Instance.
Correct: C, F
E would be correct if we use Enterprise Edition, while RAC is available with SE also where PARALLEL is not available at all.
F is correct, no doubt.
D is correct because with autoallocate according to 180608.1 performance for inserts is 35% better than any manual setting of extents.
I would also go for D and F