Oracle Database 12c: Data Guard Administrator - 1Z1-066 Free Exam Questions [2026]

QUESTION NO: 1
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 NOAFFIRM and Maximum Protection

B. ASYNC and Maximum Performance

C. SYNC AFFIRM and Maximum Availability

D. SYNC AFFIRM and Maximum Protection

E. SYNC NOAFFIRM and Maximum Availability

Discussion 0

Correct Answer: C Vote an answer

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

QUESTION NO: 2
Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)

A. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.

B. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.

C. A pluggable database within a multi-tenant standby database can have a different open mode than the container database.

D. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.

E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Discussion 0

Correct Answer: B,C Vote an answer

QUESTION NO: 3
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

A. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:physt1 FASTSYNC)';EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 SYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt2 SYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

B. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:physt1 FASTSYNC)';EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 FASTSYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt2 ASYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

C. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 ASYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt FASTSYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION

D. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 SYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt ASYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Discussion 0

Correct Answer: A Vote an answer

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

QUESTION NO: 4
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

A. It checks that supplemental logging is turned on if there is a logical standby database in the configuration.

B. It modifies the database configurable parameters to match the values set for the broker configuration.

C. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

D. It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

E. It checks that the current data protection level is consistent with the broker's configured data protection mode.

Discussion 0

Correct Answer: A,D,E Vote an answer

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

QUESTION NO: 5
Which three statements are true about snapshot standby databases? (Choose three.)

A. Tablespaces can be dropped.

B. A logical standby database can be converted into a snapshot standby database.

C. The broker may be used to fail over to a snapshot standby database.

D. Tablespaces can be created.

E. Tables can be dropped.

Discussion 0

Correct Answer: A,D,E Vote an answer

QUESTION NO: 6
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by Primary database
FS_inst Far Sync
Far_away Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?

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

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

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

QUESTION NO: 7
Attempting to start the observer raises an error:
DGMGRL> start observer;
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully. (Choose two.)

A. Set the ObserverOverride property to TRUE before starting the observer.

B. Start the observer using a different observer configuration file.

C. Start the observer in a different working directory.

D. Create a broker configuration and enable Fast-Start Failover before starting the observer.

E. Enable Fast-Start Failover before starting the observer.

Discussion 0

Correct Answer: B,C Vote an answer

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

QUESTION NO: 8
Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.)

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

B. A Physical Standby Database can be converted into a Logical 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 configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

Discussion 0

Correct Answer: A,B Vote an answer

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

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us