Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 94

Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)

Answer options

• A. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
• B. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
• C. Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.
• D. An SPFILE must be used for all the databases in a configuration.
• E. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.

Correct answer: D, E

Explanation

Answer D is correct because the use of an SPFILE is mandatory for all databases within a Data Guard configuration. Answer E is also correct since properties controlled by the Data Guard Broker cannot be modified directly, ensuring consistent management via the Broker. The other options either misrepresent the capabilities of the Broker or the treatment of initialization parameters.