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? (Choose three.)

• A. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
• B. The client applications must use the correct TNS entries when requesting connections to the database instances.
• C. The standby database services must be defined statically with the Listeners running on the standby database hosts.
• D. Client TNS entries for the databases use the correct service names for the intended service.
• E. A service name is registered with the local listener of each database instance.
• F. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
• G. The LOCAL_LISTENER parameter on the primary database instance must always be set.

Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.)

• A. They can be used to skip ALTER TABLE commands on a specific tables.
• B. They can only be used to skip DML statements on a table.
• C. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.
• D. They can be used to skip CREATE TABLE commands.
• E. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
• F. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
• G. They can be used to stop SQL apply if it encounters an error.

Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode.
2. Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports produced.
4. The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

• A. one physical standby database with Real-Time Query enabled and the
  STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• C. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• D. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)

• A. The upgrade always required downtime until the upgrade of the primary is completed.
• B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
• C. The upgrade always requires downtown until the upgrade of the logical standby is completed.
• D. Using manual upgrade, catupgrd.sql needs to run on the primary database only.
• E. Fast-Start Failover can be used to protect the primary database during the upgrade.
• F. SQL Apply on the local standby database must be stopped while the primary database is upgraded.