Which four requirements can be met by deploying a logical standby database? (Choose four.)

• A. It can be used for Real Application Testing without affecting the disaster recovery capabilities.
• B. It can be used to create additional tables.
• C. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• D. It must have the same physical structure as the primary database.
• E. It can be used to create additional schemas.
• F. Support for workloads requiring additional materialized views.
• G. Support for workloads requiring additional indexes.

Which two statements are true regarding Data Guard Broker? (Choose two.)

• A. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• B. It can be used to monitor redo transport and log apply services.
• C. It can be used to perform failovers and switchovers.
• D. It can be used to create and manage standby databases.
• E. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

Attempting to start the observer raises an error:
DGMGRL> start observer;
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully. (Choose two.)

• A. Create a broker configuration and enable Fast-Start Failover before starting the observer.
• B. Enable Fast-Start Failover before starting the observer.
• C. Start the observer in a different working directory.
• D. Set the ObserverOverride property to TRUE before starting the observer.
• E. Start the observer using a different observer configuration file.

Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

• A. The configuration operates in Maximum Performance mode.
• B. The observer is running.
• C. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
• D. An automatic failover will be initiated even if the target standby database lags behind the primary.
• E. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database.
• F. The configuration operates in Maximum Availability mode.

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)

• A. The primary database must be in archivelog mode.
• B. The primary host and the proposed standby database host must run the same operating system.
• C. The primary database instance must be started using an SPFILE.
• D. The primary database must have flashback enabled.
• E. A backup of the primary database must exist.
• F. The primary database must have FORCE LOGGING enabled.