CertsTopics Logo

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

Oracle Certification 1z0-076 Dumps PDF

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

Oracle Database 19c: Data Guard Administration Questions and Answers

Question 9

Which TWO statements are true regarding Data Guard Broker?

Options:

A.

It can be used to create and manage standby databases.

B.

It can be used to perform failovers and switchovers.

C.

It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

D.

It can be used to monitor redo transport and log apply services.

E.

It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

Question 10

A Data Guard environment has this configuration and these attributes:

    A primary database

    A physical standby database named sbdb

    The configuration is in maximum availability protection mode.

Then sbdb is converted to a snapshot standby database.

Which two statements are true?

Options:

A.

The recovery time objective increases.

B.

sbdb can still receive redo.

C.

The protection mode is lowered to maximum performance.

D.

sbdb can still apply redo.

E.

The recovery point objective increases.

Question 11

Your Data Guard environment consists of these components and settings:

1. A primary database

2. Two remote physical standby databases

3. The redo transport mode is set to sync

4. Real-time query is enabled for both standby databases

5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases

You notice an increase in redo apply lag time on both standby databases.

Which two would you recommend to reduce the redo apply lag on the standby databases?

Options:

A.

Increase the size of standby redo log files on the standby databases.

B.

Decrease the redo log file size on the primary database.

C.

Increase the number of standby redo log files on the standby databases.

D.

Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

E.

Increase the size of the buffer cache on the physical standby database instances.

Question 12

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.

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