Examice

Exam 1z0-078 All QuestionsBrowse all questions from this exam

Question 11

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

Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

Oracle RAC Resource Management only allows assignment of the SGA during database startup.

Correct Answer: C

Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA, enabling flexibility and optimized resource usage in a RAC environment. This means the SGA can be adjusted without the need for a database restart, which is critical for high availability and performance in Oracle RAC systems.

Discussion

217972fOption: C

It's C. and no need to have same settings on all nodes: https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/administering-database-instances-and-cluster-databases.html#GUID-845E2ECD-9089-4666-BFCD-C42C5F11C6C3

wiprooracleOption: C

Looks to be C