Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 91:

  A Data Guard environment has this configuration and these attributes:

  1.

  A primary database

  2.

  A Physical Standby Database named sbdb

  3.

  The configuration is in maximum availability protection mode.

  Then sbdb is converted to a snapshot standby database When two statements are true?

  A. Sdbd can still apply redo

  B. The recovery point objective increases

  C. The protection mode is lowered to maximum performance

  D. The recovery time objective increases.

  E. Sbdb can still receive redo

  Correct Answer: DE

• Question 92:

  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.

  Correct Answer: BDE

• Question 93:

  You administer a Data Guard environment consisting of a primary and three physical standby databases.

  One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.

  The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.

  The physical standby database is the only standby that is a mandatory destination

  The broker configuration operates in MAXIMUM PERFORMANCE mode.

  Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

  A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY

  B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

  C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

  D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,

  E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

  Correct Answer: B

• Question 94:

  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.

  Correct Answer: ACE

• Question 95:

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

  Which two are true about rolling release upgrades in a Data Guard environment?

  A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure

  B. A physical standby database can be converted to a logical standby database temporarily.

  C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

  D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

  E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

  Correct Answer: BD

• Question 97:

  You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.

  Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

  A. Connect to the primary database as the AUXILIARY.

  B. Catalog the data file copy for RMAN to use on the primary database for restore.

  C. Back up the data file as copy on the standby host to a location on the standby host.

  D. Switch to the data file copy using the RMAN SWITCH command.

  E. Back up the data file as copy on the standby host to a location on the primary host

  F. Connect to the primary database as the TARGET.

  Correct Answer: ABD

• Question 98:

  A customer has these requirements for their potential Data Guard implementation:

  1. Zero data loss must still be guaranteed through the loss of any one configuration component. 2 The primary database must be protected against a regional disaster

  3.

  Performance overheads on the primary should be minimized as much as possible given these requirements.

  4.

  Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

  

  Which Data Guard broker commands are needed to implement these requirements?

  A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY

  B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION

  C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

  D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1.

  FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

  Correct Answer: A

• Question 99:

  A customer asks you to propose the most appropriate solution for this set of requirements:

  1.

  We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.

  2.

  We want to generate reports from the proposed standby database at the same time that it is used for other purposes.

  3.

  Developers may need to test occasionally on a copy of the live database.

  You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

  A. a remote physical standby database with RedoRoutesvia a far sync instance

  B. a snapshot standby database with synchronous redo transport

  C. a physical standby database with real-time query enabled

  D. a logical standby database

  E. a read mostly implementation of a physical standby database

  Correct Answer: BC

• Question 100:

  Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

  A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

  B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.

  C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

  D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

  E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

  Correct Answer: D