Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 141:

  Examine this list of possible steps:

  1 Raise the compatibility level on both databases

  2.Restart SQL Apply on the upgraded logical standby database

  3 Start SQL Apply on the old primary database.

  4.

  Perform a Switchover to the logical standby database

  5.

  Upgrade the logical standby database.

  6.

  Upgrade the old primary database.

  Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

  A. 5,2.4,3,6,1
  B. 1,5,2,4,6,3
  C. 5,2,4,6,3,1
  D. 4,6,5,2,3,1
  E. 5,2,4,1
  A. 5,2.4,3,6,1

• Question 142:

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

  A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows

  As a result of this, you decide that an upgrade may use logical standby databases.

  Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary?

  A. The upgrade always requires downtown until the upgrade of the logical standby is completed
  B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
  C. The upgrade always required downtime until the upgrade of the primary is completed
  D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
  E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
  F. Fast-Start Failover can be used to protect the primary database during the upgrade.
  B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
  E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.

• Question 144:

  Examine the Data Guard configuration: Which three will be true after a switchover to Dogs?

  

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

• Question 145:

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

  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
  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.
  E. if the former primary database became a physical standby database it will always be open read-only.

• Question 147:

  Which three are always benefits of using a logical standby database?

  A. it can be used for database rolling release upgrades
  B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.
  C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
  D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
  E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
  F. it can be used for testing patches without affecting the primary database.
  C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
  D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
  F. it can be used for testing patches without affecting the primary database.

• Question 148:

  You edit the DGConnectldentifier database property using the edit database set property DGMGRL command Which two are effects of this change?

  A. The fal_client database initialization parameter on all standby databases is updated with the new value.
  B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
  C. The fal_client database initialization parameter for the specified database is updated with the new value
  D. The broker configuration must be disabled and then enabled to use the new connection property.
  E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value
  A. The fal_client database initialization parameter on all standby databases is updated with the new value.
  B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.

• Question 149:

  You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

  A. The standby database must have supplemental logging enabled.
  B. The primary database must have FORCE LOGGING enabled
  C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
  D. The primary database must have supplemental logging enabled.
  E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.
  B. The primary database must have FORCE LOGGING enabled
  C. The DG_BROKER_START parameter must be set to TRUE for both database instances.

• Question 150:

  You edit the DGConnectldentifier database property using the edit database set property DGMGRL command Which two are effects of this change?

  A. The fal_client database initialization parameter on all standby databases is updated with the new value.
  B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
  C. The fal_client database initialization parameter for the specified database is updated with the new value
  D. The broker configuration must be disabled and then enabled to use the new connection property.
  E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value
  A. The fal_client database initialization parameter on all standby databases is updated with the new value.
  B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.