Question 1

Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

Options :

A : performing role transitions when switchover requests are made

B : maintaining information about all members of the broker configuration in binary configuration files.

C :

activating role-based services appropriately in the various database instances of the configuration, based on the database role

D :

communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

E : communicating with dkon processes in other database instances that are part of the broker configuration

Answer: A,B,C

Question 2

You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.

forward in time without applying a large number of archive log files using this command:

RMAN> RECOVER STANDBY DATABASE FROM SERVICE-;

When running this command, which of the following steps can be performed automatically?

1. Remember all data file names on the standby.

2. Restart standby in nomount.

3. Restore controlfile from primary.

4. Mount standby database.

5. Rename data files from stored standby names.

6. Restore new data files to new names.

7. Recover standby.

Options :

A : 2,3,5,6,7

B : 2,3,6,7

C : 1,3,5,6,7

D : 1,2,3,4,5,6,7

E : 1, 2,3,4,6,7

Answer: E

Question 3

What is the recommended practice for patching a Logical Standby Database in a Data Guard environment?

Options :

A :

First, apply the patch to the Logical Standby Database, then apply it to the primary database.

B :

First, apply the patch to the primary database, then apply it to the Logical Standby Database.

C :

Apply the patch simultaneously to both the primary database and the Logical Standby Database.

D :

Patching is not recommended on a Logical Standby Database.

Answer: B

Question 4

Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

Options :

A : The configuration will be in Maximum Performance mode.

B : Sheep will be in the enabled state.

C : Sheep will be in the disabled state.

D : Dogs will be in the disabled state and has to be manually reinstated.

E : The configuration will be in Maximum Availability mode.

Answer: B,D,E

Question 5

Which licensing option is required to enable Oracle Active Data Guard for read-only access to the standby database?

Options :

A :

Oracle Database Standard Edition 2

B :

Oracle Database Enterprise Edition

C :

Oracle Database Personal Edition

D :

Oracle Database Express Edition

Answer: B

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: