Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

• A. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.
• B. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.
• C. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.
• D. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.
• E. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by - Primary database
FS_inst - Far Sync
Far_away - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?

• A. The Far Sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
• B. The Close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
• C. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the Close_by primary database is not able to do so.
• D. The Far Sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
• E. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

Which TWO statements are true about database parameters for databases in a Data Guard environment?

• A. LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.
• B. COMPATIBLE must have identical values for primary and standby databases.
• C. DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.
• D. If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.
• E. The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.

Which three statements are true about snapshot standby databases?

• A. Tablespaces can be dropped.
• B. Tablespaces can be created.
• C. Tables can be dropped.
• D. The switchover TO command allows a switchover operation to a snapshot standby database.
• E. A logical standby database can be converted into a snapshot standby database.
• F. The FATLOVER TO command results in a transition of a snapshot standby database to the primary role.

Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

• A. Increase the size of the buffer cache on the standby database instance.
• B. Reduce I/O latency for the storage used by the primary database.
• C. Change the protection mode to Maximum Performance.
• D. Increase the number of standby redo log files on the primary database.
• E. Increase the network bandwidth between the primary and standby databases.
• F. Change the protection mode to Maximum Protection.