Oracle Database Administration 2019 Certified Professional — Question 37

Which statement is true about Oracle Database 19c SGA Management?

Answer options

• A. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
• B. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
• C. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
• D. Oracle RAC Resource Management only allows assignment of the SGA during database startup.

Correct answer: C

Explanation

The correct answer is C, as Oracle RAC Resource Runtime Management does indeed provide capabilities for automatic and runtime adjustments of the SGA. The other options are incorrect because they suggest limitations on SGA assignment and value uniformity that do not apply to the runtime management capabilities of Oracle RAC.