Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 141:

  Which two are true about the creation of a Data Guard Broker configuration?

  A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

  B. A primary database profile may be added to the configuration prior to creating the primary database.

  C. A standby database profile may be added to the configuration prior to creating that standby database.

  D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

  E. A newly created broker configuration is in the disabled state

  Correct Answer: DE

• Question 142:

  You must configure an Oracle Data Guard environment consisting of:

  1.

  A primary database

  2.

  A Physical Standby Database

  3.

  A Snapshot 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 the primary database and on at least one standby database.

  Which redo transport mode, and which protection mode should 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

  Correct Answer: C

• Question 143:

  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.

  Correct Answer: BF

• Question 144:

  Which two Data Guard features require the use of flashback database by the broker?

  A. Read-Mostly physical standby implementations

  B. Far Sync Instances

  C. Fast-Start Failover

  D. Real Time Query

  E. Snapshot Standby databases

  Correct Answer: CE

• Question 145:

  You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent requirements:

  1.

  Data loss is not permitted.

  2.

  Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:

  3.

  It should be possible to apply and test designated patches with a minimum amount of downtime.

  4.

  Upgrading to a new database release should be performed with the least possible amount of downtime.

  5.

  New application software releases should be tested against an exact up-to-date replica of the production database.

  You propose a primary database with one physical standby database configured in Maximum Protection mode.

  Which requirements do you meet?

  A. 2,3, 4, and 5

  B. 1,2, 3,4, and 5

  C. 1 and 2

  D. only requirement 5

  E. only requirement 1

  Correct Answer: C

• Question 146:

  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

  Correct Answer: ACE

• Question 147:

  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.

  Correct Answer: BE

• Question 148:

  Which three statements are true about snapshot standby databases?

  A. Tablespaces can be dropped.

  B. Tables can be dropped

  C. The broker may be used to fail over to a snapshot standby database.

  D. A logical standby database can be converted into a snapshot standby database.

  E. Tablespaces can be created.

  Correct Answer: ABE

• Question 149:

  Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

  A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

  B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

  C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

  D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

  E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

  Correct Answer: DE

• Question 150:

  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

  Correct Answer: CD