Question 1

You have a Data Guard broker configuration consisting of:

A primary database

One local physical standby database

One far sync instance

A remote physical standby database

The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.

What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

Options :

A :

Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard broker configuration will be discovered as targets automatically and be ready to be monitored.

B :

Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

C :

Discover the primary database as a target in Enterprise Manager Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

D :

Use the DGMGRL utility to register the configuration with the Enterprise Manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.

E :

Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

Answer: C

Question 2

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?

Options :

A :

Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

B : The LOCAL_LISTENER parameter on the primary database instance must always be set.

C :

The client applications must use the correct TNS entries when requesting connections to the database instances.

D : Client TNS entries for the databases use the correct service names for the intended service.

E :

The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment

F : A service name is registered with the local listener of each database instance.

Answer: B,D,E

Question 3

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

dogs - Primary database

cats - Snapshot standby database

sheep - Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:

ORA-01034: ORACLE not available

ORA-16625: cannot reach database "dogs"

DGM-17017: unable to determine configuration status

ou wish to perform a failover to sheep. Which command, or sequence of commands, should you issue to the

broker before executing failover to sheep; using the broker?

Options :

A : DGMGRL> convert database sheep to physical standby;

B : DGMGRL> convert database cats to physical standby;

C : DGMGRL> convert database sheep to physical standby;

DGMGRL> edit configuration set protection mode as maxperformance;

DGMGRL> convert database sheep to physical standby;

D : None, because you can directly failover to a Snapshot Standby Database.

Answer: A

Question 4

What do you need to consider when creating a logical standby database using Oracle Data Guard?

Options :

A :

Network bandwidth between the primary and standby databases

B :

Number of standby databases already configured

C :

Available disk space on the primary database

D :

Types of tablespaces on the primary database

Answer: A

Question 5

What are the two types of standby databases in Oracle Data Guard?

Options :

A :

Online and offline.

B :

Primary and secondary.

C :

Physical and logical.

D :

Active and passive.

Answer: C

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: