Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 1:

  Which two statements are true regarding Data Guard Broker?

  A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
  B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
  C. it can be used to perform failovers and switchovers.
  D. It can be used to create and manage standby databases.
  E. It can be used to monitor redo transport and log apply services.
  B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
  C. it can be used to perform failovers and switchovers.

• Question 2:

  Your Data Guard environment consists of these components and settings:

  1. A primary database supporting an OLTP workload 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

  Which two are true regarding the DelayMins Database Property for the standby database?

  A. it can only be enabled for a configuration in Maximum Performance mode.
  B. It allows user errors on the primary to be recovered by using the physical standby database.
  C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
  D. it can only be enabled for a configuration in Maximum Availability mode.
  E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
  F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
  B. It allows user errors on the primary to be recovered by using the physical standby database.
  F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

• Question 3:

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

  You must configure an Oracle Data Guard environment consisting of:

  1. A primary database 2 One Physical Standby Database

  3. One Logical Standby Database You must meet these requirements:

  1.

  Primary database availability should not be compromised by the availability of the standby databases.

  2.

  Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database. Which redo transport mode and which protection mode would you configure to meet these requirements?

  A. SYNC AFFIRM and Maximum Protection
  B. SYNC NOAFFIRM and Maximum Protection
  C. SYNC AFFIRM and Maximum Availability
  D. SYNC NOAFFIRM and Maximum Availability
  E. ASYNC and Maximum Performance
  C. SYNC AFFIRM and Maximum Availability

• Question 5:

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

  Which three factors can influence the rate of redo apply on a physical standby database?

  A. the network latency between the primary and standby databases
  B. the number of archiver processes on the standby database
  C. the number and size of standby redo logs on the primary database
  D. the rate of redo generation on the primary database
  E. the number and size of standby redo logs on the standby database
  A. the network latency between the primary and standby databases
  B. the number of archiver processes on the standby database
  E. the number and size of standby redo logs on the standby database

• Question 7:

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

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

  You have a Data Guard Broker configuration called Somewhere' as shown:

  

  Which two are true about the output of this DGMGRL command?

  A. A far sync instance cannot have inconsistent properties because it has no database.
  B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.
  C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
  D. Any inconsistency reported is on an instance-specific basis.
  C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
  D. Any inconsistency reported is on an instance-specific basis.

• Question 10:

  Which two are true about database roles in an Oracle Data Guard Configuration?

  A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
  B. A Logical Standby Database can be converted to a Snapshot Standby Database.
  C. A Logical Standby Database can cascade redo to a terminal destination
  D. A Snapshot Standby Database can be a fast-start failover target
  E. A Physical Standby Database can be converted into a Logical Standby Database.
  B. A Logical Standby Database can be converted to a Snapshot Standby Database.
  E. A Physical Standby Database can be converted into a Logical Standby Database.