1z0-076

1z0-076 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Which three are prerequisites for using Data Guard Broker? (Choose three.)

  1. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.
  2. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.
  3. The primary and standby databases must run the same version of the Oracle Database server.
  4. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.
  5. If any database in the configuration in a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.
  6. DG_BROKER_START must be set to TRUE for a database instance before adding the database to the broker configuration.

Question 12

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)

  1. If backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
  2. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
  3. Primary and physical database may use different virtual recovery catalogs in the same physical recovery catalog.
  4. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
  5. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

Question 13

After converting your physical standby database to a logical standby database, you get an error: How you can rectify the error?

  1. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.
  2. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration, and enable it.
  3. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
  4. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

Question 14

Examine this command executed on a physical standby database to transition it to a logical standby database: SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby; Which two statements are true regarding the execution of this command? (Choose two.)

  1. The Managed Recovery Process (MRP0) continues applying redo data to the physical standby database until it is ready for conversion to a logical standby database.
  2. SQL apply is automatically started when transitioning to the logical standby database.
  3. Supplemental logging will be enabled on the logical standby database when the physical standby database is transitioned to the logical standby database.
  4. The DBID of the database is changed.
  5. FLASHBACK is automatically enabled when transitioning the logical standby database.
  6. It will automatically start redo apply.