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

Oracle 1z0-076 Questions Answers

Page: 6 / 8
Total 107 questions

Oracle Database 19c: Data Guard Administration Questions and Answers

Question 21

Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

Options:

A.

Configure Oracle Net connectivity on the primary host to the standby database instance.

B.

Establish user equivalence for the database software owner between the primary host and standby host.

C.

startup nomount the standby database instance.

D.

Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

E.

Put the primary database into archivelog mode.

Question 22

Which TWO statements are true for Data Guard environments with multi-tenant databases?

Options:

A.

A multi-tenant standby database can have fewer pluggable databases than the primary container database.

B.

Different pluggable databases within a logical standby database may have different guard statuses.

C.

The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.

D.

The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

E.

The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

Question 23

Your Data Guard environment has two remote physical standby databases.

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

Which will automatically redirect clients to the new primary database in case of a switchover or failover?

Options:

A.

Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both the Primary and the Standby.

B.

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

C.

Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.

D.

Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection descriptor on the clients to use that service.

Question 24

Which FOUR database parameters might be affected by or influence the creation of standby databases?

Options:

A.

DB_NAME

B.

ARCHIVE_LAG_TARGET

C.

db_file_name_convert

D.

COMPATIBLE

E.

FALSERVER

F.

STANDBY_ARCHIVE_DEST

Page: 6 / 8
Total 107 questions