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

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

Answer options

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• B. the LOCAL_LISTERNER initialization parameter must be set to the listener used to register the primary database instance.
• C. To enable Real_Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

Correct answer: D

Explanation

Option D is correct because each standby database host needs a TNS entry for connectivity to the primary database instance to ensure proper communication and failover capabilities in a Data Guard configuration. The other options describe requirements that are either incorrect or not necessary for the Data Guard Broker setup.