Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 131:

  Which two are true about the creation of a Data Guard Broker configuration?

  A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

  B. A primary database profile may be added to the configuration prior to creating the primary database.

  C. A standby database profile may be added to the configuration prior to creating that standby database.

  D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

  E. A newly created broker configuration is in the disabled state

  Correct Answer: DE

• Question 132:

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

  A. It 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.

  B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

  C. 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.

  D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

  E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

  Correct Answer: DE

• Question 133:

  Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

  A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.

  B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

  C. It checks that the current data protection level is consistent with the broker's configured data protection mode.

  D. it modifies the database configurable parameters to match the values set for the broker configuration.

  E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

  Correct Answer: ABC

• Question 134:

  After converting your physical standby database to a logical database, you get an error:

  

  How can you rectify the error?

  A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

  B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.

  C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

  D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

  Correct Answer: D

• Question 135:

  Which three are true concerning database states after a successful switchover?

  A. If the former primary database became a logical standby database it will be in mount state

  B. The new primary database will be open read-write.

  C. The former primary database will always be open.

  D. If the former primary database became a logical standby database it will be open read- write.

  E. if the former primary database became a physical standby database it will always be open read-only.

  F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

  Correct Answer: ABE

• Question 136:

  Examine the Data Guard configuration: DGMGRL> show configuration; Configuration -Animals Protection Mode MaxAvailability Databases dogs- Primary database cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1

  DGM-17017 unable to determine configuration status You wish to perform a failover to Sheep Which command, or sequence of commands, should you issue to the broker before executing "failover to

  sheep", using the broker?

  A. DGMGRL> convert database cats to physical standby,

  B. DGMGRL> convert database sheep to physical standby;

  C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;

  D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;

  E. None, because you can directly failover to a Snapshot Standby Database

  Correct Answer: C

• Question 137:

  Which two statements are true for Data Guard environments with mufti-tenant databases?

  A. Different pluggable databases within a logical standby database may have different guard statuses.

  B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

  C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.

  D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

  E. A multi-tenant standby database can have fewer pluggable databases than the primary container database

  Correct Answer: CD

• Question 138:

  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

  Correct Answer: BC

• Question 139:

  A Data Guard environment has this configuration and these attributes:

  1.

  A primary database

  2.

  A Physical Standby Database named sbdb

  3.

  The configuration is in maximum availability protection mode.

  Then sbdb is converted to a snapshot standby database When two statements are true?

  A. Sdbd can still apply redo

  B. The recovery point objective increases

  C. The protection mode is lowered to maximum performance

  D. The recovery time objective increases.

  E. Sbdb can still receive redo

  Correct Answer: DE

• Question 140:

  Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals Protection Mode: MaxAvailability Databases: Sheep- Primary database Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled) ORA-16661: the standby database needs to be reinstated Fast-Start Failover: ENABLED Configuration

  Status: WARNING And the fast-start failover configuration: DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate:

  TRUE Observer Reconnect 10 seconds Observer Override: FALSE Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO Stuck Archiver NO Datafile Offline YES Oracle error Conditions ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over: SQL> select last_failover_reason from v$fs_failover_stats; LAST_FAILOVER_REASON ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

  A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.

  B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.

  C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep

  D. Open Dogs and let the broker reinstate Dogs automatically.

  Correct Answer: C