Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 171:

  A customer asks you to propose the most appropriate solution for this set of requirements:

  1.

  We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.

  2.

  We want to generate reports from the proposed standby database at the same time that it is used for other purposes.

  3.

  Developers may need to test occasionally on a copy of the live database.

  You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

  A. a remote physical standby database with RedoRoutesvia a far sync instance
  B. a snapshot standby database with synchronous redo transport
  C. a physical standby database with real-time query enabled
  D. a logical standby database
  E. a read mostly implementation of a physical standby database
  B. a snapshot standby database with synchronous redo transport
  C. a physical standby database with real-time query enabled

• Question 172:

  Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

  A. Backups of data files taken on the primary database may be restored on a physical standby database.
  B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
  C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
  D. Backups of control files taken on a physical standby database may be restored on the primary database.
  E. Backups of data files taken on a physical standby database may be restored on a pnmary database.
  F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.
  C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
  E. Backups of data files taken on a physical standby database may be restored on a pnmary database.
  F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

• Question 173:

  Which two are true about the usage of DBMS_ROLLING?

  A. The leading group contains the original primary database.
  B. The trailing group contains the original primary database.
  C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
  D. At least one logical standby database must be part of the initial Data Guard configuration
  E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
  D. At least one logical standby database must be part of the initial Data Guard configuration
  E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

• Question 174:

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

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

  Attempting to start the observer raises an error

  DGMGRL> start observer:

  DGM-16954 Unable to open and lock the Observer configuration file Failed. Identify two possible ways to start the observer successfully

  A. Set the Observer Override property to TRUE before starting the observer
  B. Create a broker configuration and enable Fast-Start Failover before starting the observer
  C. Start the observer using a different observer configuration file.
  D. start the observer in a different working directory.
  E. Enable Fast-Start Failover before starting the observer
  C. Start the observer using a different observer configuration file.
  D. start the observer in a different working directory.

• Question 177:

  Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)

  A. Flashback database may not be used to undo a physical standby database activation.
  B. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
  C. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
  D. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.
  E. Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical standby.
  B. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
  C. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
  D. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.

• Question 178:

  Examine the Fast-start configuration

  

  Oracle Error Conditions: (none) Which three are true?

  A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
  B. An automatic failover will be initiated even if the target standby database lags behind the primary
  C. The observer is running
  D. a failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
  E. The configuration operates in Maximum Availability mode
  F. The configuration operates in Maximum Performance mode
  A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
  C. The observer is running
  E. The configuration operates in Maximum Availability mode

• Question 179:

  Examine the Data Guard configuration;

  

  What can you conclude based on this error?

  A. Cats is a snapshot standby database
  B. The redo transport mode is set to ASYNC for the standby database Sheep
  C. The redo transport mode is set to ASYNC for both standby databases
  D. The redo transport mode is set to ASYNC for the standby database Cats
  B. The redo transport mode is set to ASYNC for the standby database Sheep

• Question 180:

  Your Data Guard environment consists of these components and settings:

  1.

  A primary database

  2.

  A remote physical standby database

  3.

  Real-time query is enabled

  4.

  The redo transport mode is set to SYNC.

  5.

  The protection mode is set to Maximum Availability.

  You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

  A. Change the protection mode to Maximum Performance.
  B. Increase the size of the buffer cache on the standby database instance.
  C. Reduce I/O latency for the storage used by the primary database.
  D. Change the protection mode to Maximum Protection.
  E. Increase the network bandwidth between the primary and standby databases
  F. Increase the number of standby redo log files on the primary database
  A. Change the protection mode to Maximum Performance.
  E. Increase the network bandwidth between the primary and standby databases