1z0-066 Oracle Database 12c: Data Guard Administration

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which three statements are true about Data Guard configurations? (Choose three.)

Select all that apply, then click Submit answer.

  • All databases in one Data Guard environment must have the same database name.

  • VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.

  • For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

  • When using the Data Guard Broker, an spfile is not required.

  • Up to 30 physical standby databases may exist within one configuration.

  • The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.

Question 2

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control.

Which two are true about this change? (Choose two.)

Select all that apply, then click Submit answer.

  • If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

  • The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

  • Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

  • Fast start failover can be enabled when making the chance.

  • Real time apply will be automatically turned on.

Question 3

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)

Select all that apply, then click Submit answer.

  • The primary database must have FORCE LOGGING enabled.

  • The primary database must be in archivelog mode.

  • A backup of the primary database must exist.

  • The primary host and the proposed standby database host must run the same operating system.

  • The primary database instance must be started using an SPFILE.

  • The primary database must have flashback enabled.