Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 131:

  Examine this command executed on a physical standby database to transition it to a logical standby database:

  SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

  Which statement is true regarding the execution of this command?

  A. FLASHBACK is automatically enabled when transitioning to the logical standby database.
  B. The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
  C. Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
  D. SQL apply is automatically started when transitioning to the logical standby database.
  E. It will automatically start redo apply.
  E. It will automatically start redo apply.

• Question 132:

  Examine the Data Guard configuration:

  

  Which three will be true after a switchover to Sheep?

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

• Question 133:

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

  Examine the Data Guard configuration: DGMGRL> show configuration; Configuration -Animals Protection Mode MaxAvailability Databases dogs- Primary database cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM-17017 unable to determine configuration status You wish to perform a failover to Sheep Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

  A. DGMGRL> convert database cats to physical standby,
  B. DGMGRL> convert database sheep to physical standby;
  C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
  D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
  E. None, because you can directly failover to a Snapshot Standby Database
  C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;

• Question 135:

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

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

  Which three statements are true about snapshot standby databases?

  A. Snapshot standby databases may be used for rolling release upgrades.
  B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
  C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
  D. a snapshot standby database can have Real-Time Query enabled
  E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.
  C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
  E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

• Question 138:

  Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)

  A. A rolling release upgrade can be performed with the Data Guard environment in any protection mode.
  B. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database.
  C. The transient logical standby database used for the rolling release upgrade must have the same DBID as the primary database.
  D. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process.
  E. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.
  B. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database.
  D. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process.
  E. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.

• Question 139:

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

  Which two are true about offloading backups to a physical standby database in a Data Guard environment?

  A. The standby database must be registered in an RMAN catalog after the primary database has been registered
  B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
  C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.
  D. The standby database must be registered in an RMAN catalog before the primary database has been registered
  B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
  C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.