Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 101:

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

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

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

  Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

  A. performing role transitions when switchover requests are made

  B. communicating with DMON processes in other database instances that are part of the broker configuration

  C. activating role-based services appropriately in the various database instances of the configuration, based on the database role

  D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.

  E. maintaining information about all members of the broker configuration in binary configuration files

  Correct Answer: ABE

• Question 105:

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

  Which three factors can influence the rate of redo apply on a physical standby database?

  A. the network latency between the primary and standby databases

  B. the number of archiver processes on the standby database

  C. the number and size of standby redo logs on the primary database

  D. the rate of redo generation on the primary database

  E. the number and size of standby redo logs on the standby database

  Correct Answer: ABE

• Question 107:

  You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

  

  What is true concerning this configuration?

  A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

  B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

  C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.

  D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled

  E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

  Correct Answer: A

• Question 108:

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

  Which two are true about database roles in an Oracle Data Guard Configuration?

  A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

  B. A Logical Standby Database can be converted to a Snapshot Standby Database.

  C. A Logical Standby Database can cascade redo to a terminal destination

  D. A Snapshot Standby Database can be a fast-start failover target

  E. A Physical Standby Database can be converted into a Logical Standby Database.

  Correct Answer: BE

• Question 110:

  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