Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 171:

  Examine the Data Guard configuration:

  

  Which three will be true after a switchover to Dogs?

  A. Sheep will be an enabled logical standby database.

  B. Cats will be an enabled physical standby database

  C. Dogs will be the primary database D. Sheep will be a disabled logical standby database

  E. Cats will be a disabled physical standby database

  Correct Answer: BCE

• Question 172:

  After converting your physical standby database to a logical database, you get an error:

  

  How can you rectify the error?

  A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

  B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.

  C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

  D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

  Correct Answer: D

• Question 173:

  Examine the Data Guard configuration: Identify two possible reasons for this error.

  

  A. The FastStartFailoverTarget property is not set on Sheep.

  B. The FastStartFailoverTarget property is not set on Dogs.

  C. The FastStartFailoverTarget property is not set on DogsFSI.

  D. The LogXptMode property is set to ASYNC on Dogs.

  E. The RedoRoutes property is not set on Dogs

  F. The RedoRoutes property is not set on DogsFSI

  Correct Answer: AD

• Question 174:

  Which three statements are true about Data Guard configurations?

  A. All databases in one Data Guard environment must have the same database name.

  B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.

  C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

  D. When using the Data Guard Broker, an spfile is not required.

  E. Up to 30 physical standby databases may exist within one configuration.

  F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

  Correct Answer: AEF

• Question 175:

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

  Examine this query and its output: Which are true?

  

  A. The observer is not connected to the database on which the query was executed.

  B. Cats is a bystander database.

  C. The observer is connected to the database on which the query was executed.

  D. The observer is currently running on o17.example com

  E. The observer is not running, but should run on o17 example.com.

  Correct Answer: A

• Question 177:

  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.

  Correct Answer: BC

• Question 178:

  There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

  A. Increase the PROCESSES initialization parameter

  B. Increase the value for the MAX_SERVERS SQL apply parameter.

  C. Decrease the number of archiver processes on the standby database. D. increase the PARALLEL_MAX_SERVER initialization parameter

  D. Decrease the number of PREPARER processes

  E. Increase the RECOVERY_PARALLEUSM initialization parameter

  Correct Answer: BE

• Question 179:

  Which three are prerequisites for enabling Fast-Start Failover?

  A. The Fast-Start Failover target standby database must receive REDO directly from the primary database

  B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

  C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

  D. The configuration must be operating in either Maximum Performance or Maximum Availability mode

  E. The configuration must be operating in either Maximum Performance or Maximum Protection mode

  F. The Data Guard environment must be managed by the Data Guard Broker.

  Correct Answer: BDF

• Question 180:

  Which four database parameters might be affected by or influence the creation of standby databases?

  A. DB_NAME

  B. ARCHIVE_LAG_TARGET

  C. COMPATIBLE

  D. DB_FILE_NAME_CONVERT

  E. DB_UNIQUE_NAME

  F. FAL_SERVER

  G. STANDBY_ARCH1VE_DEST

  Correct Answer: ADEF