Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-076 - Oracle Database 19c: Data Guard Administration

Page: 4 / 4
Total 107 questions

Examine this validate command:

DGMGRL> VALIDATE DATABASE VERBOSE "";

Which THREE statements are TRUE?

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.

Your Data Guard environment contains a primary database and three standby databases with these attributes:

1. prod : Primary database

2. prod_prq : Physical standby database with real-time query enabled used by reporting applications

3. prod_lsby: Logical standby database used by DSS

4. PROD_SSBY: Snapshot standby database used for Real Application Testing

Which TWO can be used to prevent clients from connecting to the wrong database instance?

A.

Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

B.

Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

C.

Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

D.

Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

E.

Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.