Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 91:

  Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

  A. They are required on a logical standby for real-time apply
  B. They are required only for synchronous redo transport.
  C. Only standby databases can write redo to them.
  D. It is recommended to have them on the primary database.
  E. They are required on a physical standby for real-time apply.
  F. The LGWR process writes to them on a standby database.
  A. They are required on a logical standby for real-time apply
  C. Only standby databases can write redo to them.
  E. They are required on a physical standby for real-time apply.

• Question 92:

  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.
  D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

• Question 93:

  Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

  A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
  B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
  C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
  D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
  E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.
  D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

• Question 94:

  Examine the Data Guard configuration:

  

  Configuration Status: SUCCESS Which two are true?

  A. The observer must run on host ol5.example com and is currently not running.
  B. The observer will reinstate Sheep automatically after a failover, if required.
  C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
  D. The observer will detect if the primary database is unable to accept new connections
  E. The former primary database will not be reinstated automatically alter a failover.
  B. The observer will reinstate Sheep automatically after a failover, if required.
  E. The former primary database will not be reinstated automatically alter a failover.

• Question 95:

  Your expertise is requested for these customer requirements:

  1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.

  3.

  There must be no lag between the primary and standby databases that affect the reports produced.

  4.

  The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

  A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
  B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
  C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
  D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
  E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.
  B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

• Question 96:

  Which three are benefits of using the Data Guard Broker to manage standby databases?

  A. it simplifies physical standby database creation
  B. It provides an easy failover capability using a single command.
  C. it coordinates database state transitions and updates database properties dynamically.
  D. it automatically changes database properties after the protection mode for a configuration is changed
  E. It provides an easy switchover capability using a single command.
  F. It simplifies logical standby database creation.
  B. It provides an easy failover capability using a single command.
  C. it coordinates database state transitions and updates database properties dynamically.
  E. It provides an easy switchover capability using a single command.

• Question 97:

  There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

  A. Increase the PROCESSES initialization parameter
  B. Increase the value for the MAX_SERVERS SQL apply parameter.
  C. Decrease the number of archiver processes on the standby database. D. increase the PARALLEL_MAX_SERVER initialization parameter
  D. Decrease the number of PREPARER processes
  E. Increase the RECOVERY_PARALLEUSM initialization parameter
  B. Increase the value for the MAX_SERVERS SQL apply parameter.
  E. Increase the RECOVERY_PARALLEUSM initialization parameter

• Question 98:

  A Data Guard environment has this configuration and these attributes:

  1.

  The primary database prima is in the local region.

  2.

  A physical standby database physt1 is in the local region.

  3.

  A physical standby database physt2 is in a remote region.

  4.

  The primary ships redo to physt1.

  5.

  physt1 ships redo physt2.

  6.

  physt1 and physt2 have Real-Time Query enabled

  A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

  A. The sequence is usable on physt1 and physt2
  B. The sequence is usable on physt1 but not usable on physt2.
  C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.
  D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
  E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.
  C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.
  E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

• Question 99:

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

• Question 100:

  Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

  A. monitoring the redo apply rate on a physical standby
  B. monitoring the redo apply rate on a logical standby
  C. monitoring the undo generation rate on a logical standby
  D. monitoring the redo apply rate on a snapshot standby
  E. monitoring the transport lag
  F. monitoring the undo generation rate on the primary
  A. monitoring the redo apply rate on a physical standby
  E. monitoring the transport lag