Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 161:

  You must manually reinstate a database using DGMGRL

  To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

  A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
  B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
  C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
  D. The target database should be MOUNTED and DGMGRL should be connected to the target database
  E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database
  C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.

• Question 162:

  Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database

  sheep- (*) Physical standby database cats- Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

  A. The switchover succeeds but Dogs need to be reinstated
  B. The switchover succeeds but Fast-Start Failover is suspended.
  C. The switchover succeeds and Cats become the new failover target.
  D. The switchover succeeds and Dogs become the new failover target
  E. it results in an error indicating that a switchover is not allowed.
  D. The switchover succeeds and Dogs become the new failover target

• Question 163:

  A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.

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

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

  A. The upgrade requires downtime until the upgrade of the standby is completed.
  B. The broker must be disabled during the upgrade
  C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
  D. The upgrade requires downtime until the upgrade of the primary is completed.
  E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
  F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
  G. Fast-Start Failover can be used to protect the primary database during the upgrade.
  B. The broker must be disabled during the upgrade
  D. The upgrade requires downtime until the upgrade of the primary is completed.
  E. The new release of the Oracle Software must be installed on both the primary and standby database hosts

• Question 164:

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

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

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

  Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)

  A. Transfer a copy of the passwordfile from the primary host to the standby host.
  B. Run the nid utility to modify the DBID of the primary database.
  C. Create an SPFILE for the standby database.
  D. Configure Oracle Net connectivity between the primary host and the standby host.
  E. Create a standby controlfile.
  A. Transfer a copy of the passwordfile from the primary host to the standby host.
  E. Create a standby controlfile.

• Question 168:

  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 reasons for this error

  A. Fast-Start Failover is not yet enabled for this Data Guard configuration
  B. The observer configuration file is marked read-only.
  C. There is already an observer running for this Data Guard configuration.
  D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
  E. The broker configuration has not yet been created.
  B. The observer configuration file is marked read-only.
  D. There is another observer running for a Data Guard configuration which uses the same observer configuration file

• Question 169:

  Examine the Data Guard configuration:

  DGMGRL > show configuration;

  Configuration-Animals

  Protection Mode MaxPerformance

  Databases

  dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database

  Fast-Start Failover: DISABLED

  Configuration Status: SUCCESS

  You receive an error while attempting to raise the protection mode to Maximum Availability:

  DGMGDRL> edit configuration set protection mode as max availability;

  Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.

  Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

  A. DGMGRL> convert database sheep to physical standby;
  B. DGMGRL> convert database cats to physical standby;
  C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
  D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
  E. DGMGRL> edit database cats set property LogXptMode= sync;
  B. DGMGRL> convert database cats to physical standby;
  E. DGMGRL> edit database cats set property LogXptMode= sync;

• Question 170:

  Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

  A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
  C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
  E. backups of control files taken on the logical standby database if not connected to a recovery catalog
  A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
  E. backups of control files taken on the logical standby database if not connected to a recovery catalog