CertsTopics Logo

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

Download Full Version 1z0-076 Oracle Exam

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

Oracle Database 19c: Data Guard Administration Questions and Answers

Question 29

Examine this validate command:

DGMGRL> VALIDATE DATABASE VERBOSE "";

Which THREE statements are TRUE?

Options:

A.

The command performs a comprehensive set of database checks prior to a role change.

B.

The command performs a comparison of SPFILE entries between the primary database and a specified standby database.

C.

The command performs network connectivity checks between members of a broker configuration.

D.

The command can be used for a logical standby database.

E.

The command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository.

Question 30

You are licensed to use Oracle Active Data Guard.

Which TWO statements are true after enabling block change tracking on a physical standby database?

Options:

A.

It starts the RVWR process on the physical standby database instance.

B.

It starts the CTWR process on the primary database instance.

C.

It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.

D.

It starts the CTWR process on the physical standby database instance.

E.

It allows fast incremental backups to be offloaded to the physical standby database.

F.

It allows fast incremental backups to be taken on the primary database.

Question 31

Which three are prerequisites for enabling Fast-Start Failover?

Options:

A.

The Data Guard environment must be managed by the Data Guard Broker.

B.

Flashback Database must be enabled only on the Fast-Start Failover target standby database.

C.

You can specify only one standby database as the fast-start failover target.

D.

The configuration must be operating in either Maximum Performance or Maximum Protection mode.

E.

The maximum protection mode can be used, but with two or more standby databases.

F.

Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

Question 32

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

dogs - Primary database

sheep - Snapshot standby database

cats - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

You receive an error while attempting to raise the protection mode to Maximum Protection:

DGMGRL> edit configuration set protection mode as maxprotection;

Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.

Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

Options:

A.

DGMGRL> edit database dogs set property LogxptMode=sync;

B.

DGMGRL> edit database dogs set property LogXptMode=sync;

  DGMGRL> edit database cats set property LogXptMode=sync;

C.

DGMGRL> edit database cats set property LogXptMode=sync;

D.

DGMGRL> edit database dogs set property LogxptMode=sync;

  DGMGRL> edit database sheep set property LogxptMode=sync;

E.

DGMGRL> edit database dogs set property LogXptMode=sync;

  DGMGRL> edit database sheep set property LogxptMode=sync;

  DGMGRL> edit database cats set property LogXptMode=sync;

F.

DGMGRL> edit database sheep set property LogXptMode=sync;

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