Oracle Database 12c: Data Guard Administrator: 1Z0-066

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?

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

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

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. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows

As a result of this, you decide that an upgrade may use logical standby databases.

Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary?

A. The upgrade always requires downtown until the upgrade of the logical standby is completed

B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

C. The upgrade always required downtime until the upgrade of the primary is completed

D. Using manual upgrade, catupgr.sql needs to run on the primary database only.

E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.

F. Fast-Start Failover can be used to protect the primary database during the upgrade.

A Data Guard environment has this configuration and these attributes:

1.

The primary database prima is in the local region.

2.

A physical standby database physt1 is in the local region.

3.

A physical standby database physt2 is in a remote region.

4.

The primary ships redo to physt1.

5.

physt1 ships redo physt2.

6.

physt1 and physt2 have Real-Time Query enabled

A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

A. The sequence is usable on physt1 and physt2

B. The sequence is usable on physt1 but not usable on physt2.

C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.

D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.