Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 121:

  In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

  A. a snapshot standby database is the only standby database in the Data Guard configuration.
  B. A logical standby database is the only standby database in the data guard configuration.
  C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
  D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
  E. The primary and standby databases are hosted on different operating systems.
  B. A logical standby database is the only standby database in the data guard configuration.
  E. The primary and standby databases are hosted on different operating systems.

• Question 122:

  Which three statements are true about Far Sync instances?

  A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
  B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
  C. A primary database can ship redo directly to multiple Far Sync instances.
  D. They use as spfile, a standby controlfile, and standby redo logs.
  E. They work with any protection level.
  A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
  B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
  D. They use as spfile, a standby controlfile, and standby redo logs.

• Question 123:

  Which two are true about offloading backups to a physical standby database in a Data Guard environment?

  A. The standby database must be registered in an RMAN catalog after the primary database has been registered
  B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
  C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.
  D. The standby database must be registered in an RMAN catalog before the primary database has been registered
  B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
  C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

• Question 124:

  Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

  A. if the CACHE option is set then the size of the cache must be at least 100
  B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
  C. Their usage will always have a performance impact on the primary database.
  D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
  E. They must have the NOORDER and CACHE options set.
  B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
  D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
  E. They must have the NOORDER and CACHE options set.

• Question 125:

  Which two statements are true about Real-Time Query?

  A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.
  B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
  C. Real-Time Query sessions can be connected to a Far Sync instance.
  D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
  E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.
  B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
  D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

• Question 126:

  You administer a Data Guard environment consisting of a primary and three physical standby databases.

  One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.

  The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.

  The physical standby database is the only standby that is a mandatory destination

  The broker configuration operates in MAXIMUM PERFORMANCE mode.

  Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted

  form the primary as soon as it is safe to do so?

  A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
  B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
  C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
  D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
  E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
  B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

• Question 127:

  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 128:

  Which three are true about using RMAN in a Data Guard environment?

  A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
  B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
  C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
  D. Backups of control files taken on a physical standby are not interchangeable with a primary.
  E. Backups of data files taken on a physical standby are interchangeable with a primary.
  B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
  C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
  E. Backups of data files taken on a physical standby are interchangeable with a primary.

• Question 129:

  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?

  A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
  B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
  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.
  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.
  E. Archive logs on the primary database may be deleted once they are archived locally to disk.
  A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
  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.
  E. Archive logs on the primary database may be deleted once they are archived locally to disk.

• Question 130:

  Which two Data Guard features require the use of flashback database by the broker?

  A. Read-Mostly physical standby implementations
  B. Far Sync Instances
  C. Fast-Start Failover
  D. Real Time Query
  E. Snapshot Standby databases
  C. Fast-Start Failover
  E. Snapshot Standby databases