Which three are benefits of using the Data Guard Broker to manage standby databases?
A.
It simplifies physical standby database creation.
B.
It provides an easy failover capability using a single command.
C.
It coordinates database state transitions and updates database properties dynamically.
D.
It automatically changes database properties after the protection mode for a configuration is changed.
E.
It provides an easy switchover capability using a single command.
F.
It simplifies logical standby database creation.
G.
It load balances connections between the primary and all the standby database instances that are open as
read-only for reporting.
Explanation:
BE: The broker simplifies switchovers and failovers by allowing you to invoke them using a single key click in
Oracle Enterprise Manager or a single command at the DGMGRL command-line interface (referred to in this
documentation as manual failover).
C: The broker coordinates database state transitions and update database properties dynamically with the
broker recording the changes in a broker configuration file that includes profiles of all the databases in the
configuration. The broker propagates the changes to all databases in the configuration and their server
parameter files.
https://docs.oracle.com/cd/E11882_01/server.112/e40771/concepts.ht
– Coordinates database state transitions and update database properties dynamically, with the broker recording the changes in a broker configuration file that includes information about all the databases in the configuration. The broker propagates the changes to all databases in the configuration and their server parameter files.
– The broker simplifies switchovers and failover buy allowing you to invoke them using a single key click in Cloud Control or a single command at the DGMGRL command line interface.
https://docs.oracle.com/database/121/DGBKR/concepts.htm#DGBKR020
BCE
B,C,E