CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Last Attempt 1z0-066 Questions

Page: 3 / 4
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF

Oracle Database 12c: Data Guard Administrator Questions and Answers

Question 9

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)

Options:

A.

Transfer a copy of the passwordfile from the primary host to the standby host.

B.

Run the nid utility to modify the DBID of the primary database.

C.

Create an SPFILE for the standby database.

D.

Configure Oracle Net connectivity between the primary host and the standby host.

E.

Create a standby controlfile.

Question 10

Which two Data Guard features require the use of flashback database by the broker? (Choose two.)

Options:

A.

Read-Mostly physical standby implementations

B.

Far Sync Instances

C.

Fast-Start Failover

D.

Real Time Query

E.

Snapshot Standby databases

Question 11

Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment? (Choose two.)

Options:

A.

A flash recovery area must be configured.

B.

The database must be in MOUNT state.

C.

The database must be in ARCHIVELOG mode.

D.

A far sync instance must be configured to flash back a standby when the primary has been flashed back.

E.

The Data Guard Broker must be used.

Question 12

You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN.

You are planning to create a Data Guard Broker configuration.

You execute the command:

DGMGRL> CREATE CONFIGURATION ‘DGConfig’ AS

> PRIMARY DATABASE IS ‘PROD’

> CONNECT IDENTIFIER IS PROD;

Which three statements are true regarding the execution of the command? (Choose three.)

Options:

A.

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

B.

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

C.

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

D.

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.

E.

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

F.

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

Page: 3 / 4
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF