Which three statements are tuning recommendations for R…

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

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

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *