Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 151:

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

  Which four are true about DGMGRL show command?

  A. It can be used to show properties of a pluggable standby database.

  B. it can be used to show properties of a pluggable primary database.

  C. it can be used to show instance-specific properties for a RAC database.

  D. it can be used to show properties of a far sync instance

  E. it can be used to show Fast Start Failover properties.

  F. It can be used to show properties of a primary container database.

  Correct Answer: ABEF

• Question 153:

  Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

  A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

  B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered

  C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

  D. backups of data files taken on the logical standby database, if not connected to a recovery catalog

  E. backups of control files taken on the logical standby database if not connected to a recovery catalog

  Correct Answer: ADE

• Question 154:

  Which three are required in order to use Real-Time Query without lagging behind the primary?

  A. There must be standby redo logs on the standby database

  B. There must be standby redo logs on the primary database.

  C. The primary must ship redo asynchronously.

  D. COMPATIBLE must be set to 11.1.0 or higher.

  E. Real-Time apply must be enabled on the standby.

  Correct Answer: ADE

• Question 155:

  Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

  A. The primary database must have FORCE LOGGING enabled.

  B. The primary database must be in archive log mode

  C. A backup of the primary database must exist.

  D. The primary host and the proposed standby database host must run the same operating system.

  E. The primary database instance must be started using an SPFILE.

  F. The primary database must have flashback enabled

  Correct Answer: AB

• Question 156:

  You must design an Oracle Data Guard configuration for an OLTP database 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:

  1.

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

  2.

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

  3.

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

  primary database.

  Which configuration meets these requirements with the fewest databases?

  A. a primary database with three physical standby databases

  B. a primary database with one logical and two physical standby databases

  C. a primary database with one logical standby database

  D. a primary database with one logical and one physical standby database

  E. a primary database with two physical standby databases

  F. a primary database with one physical standby database

  Correct Answer: D

• Question 157:

  Which three are true concerning database states after a successful switchover?

  A. If the former primary database became a logical standby database it will be in mount state

  B. The new primary database will be open read-write.

  C. The former primary database will always be open.

  D. If the former primary database became a logical standby database it will be open read- write.

  E. if the former primary database became a physical standby database it will always be open read-only.

  F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

  Correct Answer: ABE

• Question 158:

  Examine the Data Guard configuration: Which three will be true after a successful failover to Cats?

  

  A. Sheep will be in the disabled state.

  B. Sheep will be in the enabled state.

  C. Dogs will be in the disabled state and has to be manually reinstated

  D. The configuration will be in Maximum Performance mode.

  E. The configuration will be in Maximum Availability mode.

  Correct Answer: BCD

• Question 159:

  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 reasons for this error

  A. Fast-Start Failover is not yet enabled for this Data Guard configuration

  B. The observer configuration file is marked read-only.

  C. There is already an observer running for this Data Guard configuration.

  D. There is another observer running for a Data Guard configuration which uses the same observer configuration file

  E. The broker configuration has not yet been created.

  Correct Answer: BD

• Question 160:

  Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

  A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.

  B. Put the primary database into archivelog mode

  C. Startup nomount the standby database instance.

  D. Configure Oracle Net connectivity on the primary host to the standby database instance.

  E. Establish user equivalence for the database software owner between the primary host and standby host.

  Correct Answer: CDE