Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 81:

  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.
  C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep

• Question 82:

  Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)

  A. The configuration transport mode may be modified while the entire configuration is disabled from broker management.
  B. Database properties may be modified when that database is disabled from broker management.
  C. A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
  D. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
  E. The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
  B. Database properties may be modified when that database is disabled from broker management.
  C. A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
  D. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.

• Question 83:

  Examine the Data Guard configuration:

  

  Which three will be true after a switchover to Sheep?

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

• Question 84:

  You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control Which two are true about this change?

  A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
  B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
  C. 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.
  D. Fast start failover can be enabled when making the chance.
  E. Real time apply will be automatically turned on.
  B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
  C. 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.

• Question 85:

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

  A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
  B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
  C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
  D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database
  E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.
  A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
  D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database

• Question 86:

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

• Question 87:

  Which three statements are true about Data Guard configurations?

  A. All databases in one Data Guard environment must have the same database name.
  B. 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.
  C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
  D. When using the Data Guard Broker, an spfile is not required.
  E. Up to 30 physical standby databases may exist within one configuration.
  F. 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
  A. All databases in one Data Guard environment must have the same database name.
  E. Up to 30 physical standby databases may exist within one configuration.
  F. 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 88:

  Your Data Guard environment has two remote physical standby databases

  Client applications use the local naming method to connect to the primary database instance.

  You want applications to automatically connect to the new primary database instance in case of a switchover or a failover

  Which will fulfill this requirement?

  A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
  B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
  C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
  D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.
  A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.

• Question 89:

  Examine this query and its output:

  

  Which are true?

  A. The observer is not connected to the database on which the query was executed.
  B. Cats is a bystander database.
  C. The observer is connected to the database on which the query was executed.
  D. The observer is currently running on o17.example com
  E. The observer is not running, but should run on o17 example.com.
  A. The observer is not connected to the database on which the query was executed.

• Question 90:

  Which two are true about database roles in an Oracle Data Guard Configuration?

  A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
  B. A Logical Standby Database can be converted to a Snapshot Standby Database.
  C. A Logical Standby Database can cascade redo to a terminal destination
  D. A Snapshot Standby Database can be a fast-start failover target
  E. A Physical Standby Database can be converted into a Logical Standby Database.
  B. A Logical Standby Database can be converted to a Snapshot Standby Database.
  E. A Physical Standby Database can be converted into a Logical Standby Database.