Try our Free Demo Practice Tests for Comprehensive 1Z0-076 Exam Preparation

The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance. 

The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

LOG_STANDBY_FORMAT

LOG_ARCHIVE_CONFIG

DB_UNIQUE_NAME

LOG_APPLY_SERVICES

lsnrctl start

sqlplus

tnsping

net start

A logical standby database consumes less storage space than a physical standby database.

A logical standby database allows read/write access for reporting purposes.

A logical standby database requires less network bandwidth for redo transfer.

A logical standby database provides faster recovery times in case of failures.

Improved performance.

No impact on performance.

Minimal impact.

Significant performance degradation.