Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 101:

  You must configure an Oracle Data Guard environment consisting of:

  1. A primary database 2 Three Physical Standby Databases You must meet these requirements: A designated physical standby database should become the primary database automatically whenever the primary database falls The chosen protection mode should provide the highest level of protection possible without violating the other

  requirement Which redo transport mode and protection mode would you configure to meet these requirements?

  A. SYNC NOAFFRIM and Maximum Protection
  B. SYNC NOAFFIRM and Maximum Availability
  C. ASYNC and Maximum Performance
  D. SYNC AFFIRM and Maximum Availability
  E. SYNC AFFIRM and Maximum Protection
  D. SYNC AFFIRM and Maximum Availability

• Question 102:

  Which two are true about the usage of DBMS_ROLLING?

  A. The leading group contains the original primary database.
  B. The trailing group contains the original primary database.
  C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
  D. At least one logical standby database must be part of the initial Data Guard configuration
  E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
  D. At least one logical standby database must be part of the initial Data Guard configuration
  E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

• Question 103:

  Examine the Data Guard configuration after an accidental switchover to Sheep:

  

  Which three will be true after a switchover to Dogs?

  A. Sheep will be a disabled logical standby database.
  B. Sheep will be an enabled logical standby database.
  C. Cats will be a disabled physical standby database that can be manually enabled.
  D. Cats will be an enabled physical standby database.
  E. Dogs will be the primary database.
  B. Sheep will be an enabled logical standby database.
  C. Cats will be a disabled physical standby database that can be manually enabled.
  E. Dogs will be the primary database.

• Question 104:

  A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

  A. Recover the datafile by using the RMAN RECOVER DATAFILE command
  B. Restart the redo apply.
  C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  D. Stop the redo apply.
  E. Recover the database by using the RMAN RECOVER DATABASE command.
  C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  D. Stop the redo apply.
  E. Recover the database by using the RMAN RECOVER DATABASE command.

• Question 105:

  A customer has these requirements for their potential Data Guard implementation:

  1. Zero data loss must still be guaranteed through the loss of any one configuration component. 2 The primary database must be protected against a regional disaster

  3.

  Performance overheads on the primary should be minimized as much as possible given these requirements.

  4.

  Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

  

  Which Data Guard broker commands are needed to implement these requirements?

  A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
  B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
  C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
  D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
  A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY

• Question 106:

  Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

  A. performing role transitions when switchover requests are made
  B. communicating with DMON processes in other database instances that are part of the broker configuration
  C. activating role-based services appropriately in the various database instances of the configuration, based on the database role
  D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
  E. maintaining information about all members of the broker configuration in binary configuration files
  A. performing role transitions when switchover requests are made
  B. communicating with DMON processes in other database instances that are part of the broker configuration
  E. maintaining information about all members of the broker configuration in binary configuration files

• Question 107:

  Which three factors can influence the rate of redo apply on a physical standby database?

  A. the network latency between the primary and standby databases
  B. the number of archiver processes on the standby database
  C. the number and size of standby redo logs on the primary database
  D. the rate of redo generation on the primary database
  E. the number and size of standby redo logs on the standby database
  A. the network latency between the primary and standby databases
  B. the number of archiver processes on the standby database
  E. the number and size of standby redo logs on the standby database

• Question 108:

  Your Data Guard environment consists of these components and settings:

  1. A primary database supporting an OLTP workload 2 A remote physical standby database

  3.

  Real-time query is enabled

  4.

  The redo transport mode is set to SYNC.

  5.

  The protection mode is set to Maximum Availability

  Which two are true regarding the DelayMins Database Property for the standby database?

  A. it can only be enabled for a configuration in Maximum Performance mode.
  B. It allows user errors on the primary to be recovered by using the physical standby database.
  C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
  D. it can only be enabled for a configuration in Maximum Availability mode.
  E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
  F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
  B. It allows user errors on the primary to be recovered by using the physical standby database.
  F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

• Question 109:

  A customer asks you to propose the most appropriate solution for this set of requirements:

  1.

  We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.

  2.

  We want to generate reports from the proposed standby database at the same time that it is used for other purposes.

  3.

  Developers may need to test occasionally on a copy of the live database.

  You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

  A. a remote physical standby database with RedoRoutesvia a far sync instance
  B. a snapshot standby database with synchronous redo transport
  C. a physical standby database with real-time query enabled
  D. a logical standby database
  E. a read mostly implementation of a physical standby database
  B. a snapshot standby database with synchronous redo transport
  C. a physical standby database with real-time query enabled

• Question 110:

  Your Data Guard environment consists of these components and settings:

  1.

  A primary database

  2.

  A remote physical standby database

  3.

  Real-time query is enabled

  4.

  The redo transport mode is set to SYNC.

  5.

  The protection mode is set to Maximum Availability.

  You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

  A. Change the protection mode to Maximum Performance.
  B. Increase the size of the buffer cache on the standby database instance.
  C. Reduce I/O latency for the storage used by the primary database.
  D. Change the protection mode to Maximum Protection.
  E. Increase the network bandwidth between the primary and standby databases
  F. Increase the number of standby redo log files on the primary database
  A. Change the protection mode to Maximum Performance.
  E. Increase the network bandwidth between the primary and standby databases