Question 1

What is the primary purpose of configuring Oracle Net Services in a Data Guard environment?

Options :

A : To ensure high availability and failover of the databases

B : To enable database replication between the primary and standby databases

C : To secure the transmission of data between primary and standby databases

D : To manage the network connections between primary and standby databases

Answer: D

Question 2

Which feature of a Logical Standby Database allows for real-time reporting and querying?

Options :

A : Oracle Flashback Database

B : Oracle Active Data Guard

C : Oracle Data Pump

D : Oracle Multi-Tenant

Answer: B

Question 3

Which initialization parameter needs to be set to enable a snapshot standby database?

Options :

A : ENABLE_SNAPSHOT_STANDBY

B : ENABLE_DGMGRL_SNAPSHOT

C : DB_RECOVERY_FILE_DEST

D : STANDBY_ARCHIVE_DEST

Answer: A

Question 4

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting. Switchovers or failovers are possible due to testing or in case of a disaster.Clients use local TNSNAMES.ORA files to define connection strings to the database instances. Which three will prevent clients from connecting to the wrong database instances?

Options :

A : Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

B : The LOCAL_LISTENER parameter on the primary database instance must always be set.

C : The client applications must use the correct TNS entries when requesting connections to the database instances.

D : Client TNS entries for the databases use the correct service names for the intended service.

E : The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment

F : A service name is registered with the local listener of each database instance.

Answer: B,D,E

Question 5

What happens to the changes made in a Snapshot Standby database when it is converted back to a physical standby database?

Options :

A : The changes are discarded

B : The changes are applied to the primary database

C : All changes are lost

Answer: B