Question 1

Which Data Guard protection mode ensures zero data loss in the event of a primary database failure?

Options :

A :

Maximum Performance

B :

Maximum Availability

C :

Maximum Durability

D :

Maximum Protection

Answer: D

Question 2

Which command is used to test a network connection using TNSPING utility?

Options :

A :

tnsping

B :

traceroute

C :

telnet

D : ping

Answer: A

Question 3

What are the primary components of Oracle Data Guard?

Options :

A :

Primary database, auxiliary database, and flash recovery area.

B :

Control file, data file, and redo log file.

C :

Primary database, standby database, and observer.

D :

Physical standby database, logical standby database, and snapshot standby database.

Answer: C

Question 4

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

Options :

A :

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

B :

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

C :

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.

D :

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

E :

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.

F :

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

Answer: A,D,E

Question 5

Which command is used to change the default password for the Data Guard Broker?

Options :

A :

CHANGE PASSWORD

B :

SET PASSWORD

C :

ALTER SYSTEM

D :

ALTER CONFIGURATION

Answer: B

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: