Oracle Database 12c: Data Guard Administrator (1Z0-066) Free Practice Test

Question 1

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: ol7.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
Health Conditions:
Corrupted ControlfileYES
Corrupted DictionaryYES
Inaccessible Logfile NO
Stuck ArchiverNO
Datafile OfflineYES
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. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep.

B. Open Dogs and let the broker reinstate Dogs automatically.

C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.

D. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Which four requirements can be met by deploying a logical standby database? (Choose four.)

A. It can be used to create additional tables.

B. Support for workloads requiring additional materialized views.

C. It must have the same physical structure as the primary database.

D. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

E. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

F. It can be used to create additional schemas.

G. Support for workloads requiring additional indexes.

Correct Answer: A,D,E,G

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

C. To enable Real_Time 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 entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E. the LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)

A. Database properties may be modified when that database is disabled from broker management.

B. A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.

C. The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.

D. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.

E. The configuration transport mode may be modified while the entire configuration is disabled from broker management.

Correct Answer: A,B,D

Question 5

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)

A. Run the nid utility to modify the DBID of the primary database.

B. Configure Oracle Net connectivity between the primary host and the standby host.

C. Transfer a copy of the passwordfile from the primary host to the standby host.

D. Create an SPFILE for the standby database.

E. Create a standby controlfile.

Correct Answer: C,E

Question 6

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

A. a read mostly implementation of a physical standby database

B. a remote physical standby database with RedoRoutes via a far sync instance

C. a physical standby database with real-time query enabled

D. a snapshot standby database with synchronous redo transport

E. a logical standby database

Correct Answer: C,D

Welcome to TestSimulate

Oracle Database 12c: Data Guard Administrator (1Z0-066) Free Practice Test