CertsTopics Logo

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

Oracle Certification 1z0-076 Exam Questions and Answers PDF

Page: 2 / 8
Total 107 questions
Get 1z0-076 Full Access Download 1z0-076 PDF

Oracle Database 19c: Data Guard Administration Questions and Answers

Question 5

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to connect to the primary database instance.

You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.

Which set of actions will fulfill this requirement?

Options:

A.

Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

B.

Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

C.

Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

D.

Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

Question 6

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

Options:

A.

To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

B.

To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

C.

A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D.

A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E.

The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Question 7

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: Max Availability

Databases:

dogs - Primary database sheep

- Physical standby database cats

- Physical standby database

Fast-Start Failover: DISABLED

Configuration Status: SUCCESS

An attempt to enable fast-start failover raises an error:

DGMGRL> enable fast_start failover;

Error: ORA-16693: requirements not met for enabling fast-start failover

Failed.

Identify three possible reasons for this error.

Options:

A.

The fastStartFailoverTarget property is not set on Dogs.

B.

The LogxptModr property is set to async on Sheep while Sheep is the target standby database.

C.

The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.

D.

The LogXptMode property is set to async on Dogs.

E.

The LogXptMode property is set to fastsync on Dogs.

Question 8

Which three statements are true about Data Guard database modes and states?

Options:

A.

Force Logging Mode is not required for a primary database but is recommended.

B.

The Primary Database can operate in noarchivelog mode.

C.

A Logical Standby Database can be in MOUNT state while applying changes.

D.

Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

E.

A primary database may ship redo directly to more than nine standby databases.

Page: 2 / 8
Total 107 questions
Get 1z0-076 Full Access Download 1z0-076 PDF