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

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

A. Tablespaces can be dropped. B. Tables can be dropped. C. Tablespaces can be created. D. The broker may be used to fail over to a snapshot standby database. E. A logical standby database can be converted into a snapshot standby database.

Correct Answer: A,B,C

QUESTION NO: 2
Examine the Data Guard configuration:
DGMGRL> show configuration verbose;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
cats - Primary database
dogs - (*) Physical standby database
sheep - Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutoReinstate= 'FALSE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'none'
ObserverOverride = 'FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol5.example.com
Lag Limit: 30 seconds
Shutdown Primary:TRUE
Auto-reinstate: FALSE
Observer Reconnect: 10 seconds
Observer Override: TRUE
Configuration Status:
SUCCESS
Which two are true? (Choose two.)

A. The observer will reinstate Sheep automatically after a failover, if required. B. The former primary database will not be reinstated automatically after a failover. C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable. D. The observer must run on host ol5.example.com and is currently not running. E. The observer will detect if the primary database is unable to accept new connections.

Correct Answer: A,B

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

QUESTION NO: 3
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
cats Physical standby database
sheep Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Sheep? (Choose three.)

A. Dogs will be a disabled logical standby database. B. Cats will be a disabled physical standby database. C. Dogs will be an enabled logical standby database. D. Cats will be an enabled physical standby database. E. Sheep will be the primary database.

Correct Answer: B,C,E

QUESTION NO: 4
Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration Animals
Protection Mode: MaxAvailability
Databases:
cats Primary database
dogs Physical standby database
sheep Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)

A. Sheep will be a disabled logical standby database. B. Cats will be a disabled physical standby database. C. Sheep will be an enabled logical standby database. D. Dogs will be the primary database. E. Cats will be an enabled physical standby database.

Correct Answer: C,D,E

QUESTION NO: 5
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service. B. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance. C. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host. D. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.

Correct Answer: B

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

QUESTION NO: 6
Which four are true about DGMGRL show command? (Choose four.)

A. It can be used to show properties of a primary container database. B. It can be used to show properties of a pluggable primary database. C. It can be used to show Fast Start Failover properties. D. It can be used to show properties of a far sync instance. E. It can be used to show instance-specific properties for a RAC database. F. It can be used to show properties of a pluggable standby database.

Correct Answer: A,B,C,F

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