Question 1

Which initialization parameter specifies the destinations where archived redo logs are shipped in a Logical Standby Database configuration?

Options :

A :

LOG_ARCHIVE_DEST_STATE_1

B :

LOG_ARCHIVE_DEST_2

C :

LOG_ARCHIVE_DEST_STATE_2

D :

LOG_ARCHIVE_DEST_1

Answer: D

Question 2

You are using Data Guard in conjunction with Global Database Services. You have a Data Guard Broker configuration called Sales and a GDS pool called Prod. Which three are true concerning the management of the broker configuration when using GDS?

Options :

A : DGMGRL may be used to add the Sales configuration to the Prod pool in gds.

B :

Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

C :

DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.

D :

Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

E :

Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

Answer: A,B,C

Question 3

Which of the following commands can be used to create a physical standby database in Oracle?

Options :

A :

CREATE STANDBY DATABASE

B :

CREATE DATABASE

C :

CREATE STANDBY INCREMENTAL

D :

CREATE STANDBY CONTROLFILE

Answer: A

Question 4

What is the primary purpose of Oracle Net Services in a Data Guard environment?

Options :

A :

Managing database storage in a Data Guard configuration

B :

Facilitating network communication between primary and standby databases

C :

Enforcing security measures in a Data Guard environment

D :

Monitoring and managing database performance in a Data Guard setup

Answer: B

Question 5

Which configuration file is used to specify the network connection parameters for the primary and standby databases?

Options :

A :

tnsnames.ora

B :

listener.ora

C :

sqlnet.ora

D :

init.ora

Answer: C

Confidently Practice Online with Free 1Z0-076 Exam Cram

Buying Options: