Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 181:

  Examine the Data Guard configuration after an accidental switchover to Sheep: Which three will be true after a switchover to Dogs?

  

  A. Sheep will be a disabled logical standby database.

  B. Sheep will be an enabled logical standby database.

  C. Cats will be a disabled physical standby database that can be manually enabled.

  D. Cats will be an enabled physical standby database.

  E. Dogs will be the primary database.

  Correct Answer: BCE

• Question 182:

  You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control

  Which two are true about this change?

  A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

  B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

  C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

  D. Fast start failover can be enabled when making the chance.

  E. Real time apply will be automatically turned on.

  Correct Answer: BC

• Question 183:

  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

  Correct Answer: C

• Question 184:

  Your Data Guard environment has one physical standby database using Real-Time Query.

  Two sentences have been created by these SQL statements:

  create sequence a global; create sequence b session;

  Neither sequence has been used since being created

  Session 1 connects to the primary database instance and issues these two SQL statements:

  SELECT a.nextval FROM DUAL;

  SELECT b nextval FROM DUAL;

  Then session 2 connects to the physical standby database instance and issues the same SQL statements.

  What output will be seen for session 2?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 185:

  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

  Correct Answer: A

• Question 186:

  Which four requirements can be met by deploying a logical standby database?

  A. Support for workloads requiring additional indexes.

  B. it can be used to create additional schemas.

  C. it can be used to create additional tables.

  D. It must have the same physical structure as the primary database.

  E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

  F. Support for workloads requiring additional materialized views.

  G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

  Correct Answer: ACEG

• Question 187:

  In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

  A. a snapshot standby database is the only standby database in the Data Guard configuration.

  B. A logical standby database is the only standby database in the data guard configuration.

  C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.

  D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.

  E. The primary and standby databases are hosted on different operating systems.

  Correct Answer: BE

• Question 188:

  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.

  Correct Answer: CE

• Question 189:

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

  Which two are true about management of a far sync instance when using the Data Guard Broker?

  A. A far sync instance is in a disabled state in the broker configuration immediately after adding it

  B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.

  C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.

  D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

  Correct Answer: AB