1z0-066 Free Practice Test

You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

1. A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
2. B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
3. C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
4. D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
5. E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Correct Answer: ADE

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?

1. A. The upgrade always requires downtown until the upgrade of the logical standby is completed
2. B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
3. C. The upgrade always required downtime until the upgrade of the primary is completed
4. D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
5. E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
6. F. Fast-Start Failover can be used to protect the primary database during the upgrade.

Correct Answer: BE

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

1. A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
2. B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
3. C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
4. D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
5. E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host

Correct Answer: AB

Which two are true about rolling release upgrades in a Data Guard environment?

1. A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure
2. B. A physical standby database can be converted to a logical standby database temporarily.
3. C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.
4. D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
5. E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Correct Answer: BD

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

1. A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
2. B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
3. C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
4. D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
5. E. A TNS entry or entries enabling connectivity to standby database instance(s) must bedefined on the primary database host.

Correct Answer: D