Refresh 1z0-066 Exam Answers For Oracle Database 12c: Data Guard Administration Certification

NEW QUESTION 1
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?

• A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
• B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
• C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
• D. Fast start failover can be enabled when making the chance.
• E. Real time apply will be automatically turned on.

Answer: BC

NEW QUESTION 2
Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration:
DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs
Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE
Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO
Stuck Archiver NO Datafile Offline YES Oracle error Conditions
ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats; LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

• A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

NEW QUESTION 3
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 4
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 2 A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability
Which two are true regarding the DelayMins Database Property for the standby database?

• A. it can only be enabled for a configuration in Maximum Performance mode.
• B. It allows user errors on the primary to be recovered by using the physical standby database.
• C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
• D. it can only be enabled for a configuration in Maximum Availability mode.
• E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
• F. It specifies a delay before the primary ships redo to the standby destination havingDelayMins set.

Answer: BF

NEW QUESTION 5
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 6
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

Answer: ABE

NEW QUESTION 7
Which two are true about management of a far sync instance when using the Data Guard Broker?

• A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
• B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
• C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
• D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

NEW QUESTION 8
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.

Answer: DE

NEW QUESTION 9
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.

Answer: A

NEW QUESTION 10
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations
• B. Far Sync Instances
• C. Fast-Start Failover
• D. Real Time Query
• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 11
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?

• A. it allows fast incremental backups to be offloaded to the physical standby database
• B. It starts the CTWR process on the physical standby database instance
• C. it allows fast incremental backups to be taken on the primary database.
• D. It starts the RVWR process on the physical standby database instance.
• E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
• F. It starts the CTWR process on the primary database instance.

Answer: AB

NEW QUESTION 12
Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports
produced.
4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

• A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.

Answer: B

NEW QUESTION 13
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these
requirements?

• A. SYNC AFFIRM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Answer: C

NEW QUESTION 14
A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. physt1 and physt2 have Real-Time Query enabled
A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

• A. The sequence is usable on physt1 and physt2
• B. The sequence is usable on physt1 but not usable on physt2.
• C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primarydatabase.
• D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E. physt2 will no longer receive redo if physt1 becomes unavailable, unlessLOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

NEW QUESTION 15
Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals
Protection Mode: MaxAvailability Databases:
dogs- Primary database
sheep- (*) Physical standby database cats- Physical standby database
Fast-Start Failover: ENABLED Configuration Status: SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

• A. The switchover succeeds but Dogs need to be reinstated
• B. The switchover succeeds but Fast-Start Failover is suspended.
• C. The switchover succeeds and Cats become the new failover target.
• D. The switchover succeeds and Dogs become the new failover target
• E. it results in an error indicating that a switchover is not allowed.

Answer: D

NEW QUESTION 16
......