Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 61:

  Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

  A. a flash recovery area must be configured

  B. The database must be in MOUNT state.

  C. The database must be in ARCHIVELOG mode.

  D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.

  E. The Data Guard Broker must be used.

  Correct Answer: AC

• Question 62:

  Which two are true about the usage of DBMS_ROLLING?

  A. The leading group contains the original primary database.

  B. The trailing group contains the original primary database.

  C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.

  D. At least one logical standby database must be part of the initial Data Guard configuration

  E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

  Correct Answer: DE

• Question 63:

  Examine the Data Guard configuration;

  

  What can you conclude based on this error?

  A. Cats is a snapshot standby database

  B. The redo transport mode is set to ASYNC for the standby database Sheep

  C. The redo transport mode is set to ASYNC for both standby databases

  D. The redo transport mode is set to ASYNC for the standby database Cats

  Correct Answer: B

• Question 64:

  You must configure an Oracle Data Guard environment consisting of:

  1. A primary database

  2 Three Physical Standby Databases

  You must meet these requirements:

  A designated physical standby database should become the primary database automatically whenever the primary database falls The chosen protection mode should provide the highest level of protection possible without violating the other requirement Which redo transport mode and protection mode would you configure to meet these requirements?

  A. SYNC NOAFFRIM and Maximum Protection

  B. SYNC NOAFFIRM and Maximum Availability

  C. ASYNC and Maximum Performance

  D. SYNC AFFIRM and Maximum Availability

  E. SYNC AFFIRM and Maximum Protection

  Correct Answer: D

• Question 65:

  Your Data Guard environment has two remote physical standby databases

  Client applications use the local naming method to connect to the primary database instance.

  You want applications to automatically connect to the new primary database instance in case of a switchover or a failover

  Which will fulfill this requirement?

  A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.

  B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

  C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

  D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.

  Correct Answer: A

• Question 66:

  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

• Question 67:

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

  You must configure an Oracle Data Guard environment consisting of:

  1. A primary database

  2 Three Physical Standby Databases

  You must meet these requirements:

  A designated physical standby database should become the primary database automatically whenever the primary database falls The chosen protection mode should provide the highest level of protection possible without violating the other requirement Which redo transport mode and protection mode would you configure to meet these requirements?

  A. SYNC NOAFFRIM and Maximum Protection

  B. SYNC NOAFFIRM and Maximum Availability

  C. ASYNC and Maximum Performance

  D. SYNC AFFIRM and Maximum Availability

  E. SYNC AFFIRM and Maximum Protection

  Correct Answer: D

• Question 69:

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

  A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

  A. Recover the datafile by using the RMAN RECOVER DATAFILE command

  B. Restart the redo apply.

  C. Restore the datafile by using the RMAN RESTORE DATAFILE command.

  D. Stop the redo apply.

  E. Recover the database by using the RMAN RECOVER DATABASE command.

  Correct Answer: CDE