Oracle Database 12c: Data Guard Administrator - 1Z1-066 Exam Practice Test

Examine the Data Guard configuration:
Properties:
FastStartFailoverThreshold= '30'
OperationTimeout= '30'
TraceLevel= 'USER'
FastStartFailoverLagLimit= '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutReinstate= 'TRUE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'all'
ObserverOverride= 'FALSE'
Fast-Start Failover:ENABLED
Threshold:30 seconds
Target:dogs
Observer:prutser6.example.com
Lag Limit:30 seconds (not in use)
Shutdown Primary:TRUE
Auto-reinstate:TRUE
Observer Reconnect:10 seconds
Observer Override:
Configuration Status:
SUCCESS
What happens if you issue "failover to dogs;" at the DGMGRL prompt while connected to Dogs?
Correct Answer: E
The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1.
2) Disable Fast-Start Failover.
3) Update the broker configuration with the new observer hostname.
4) Enable Fast-Start Failover.
5) Start the Observer on host2.
Which contains the minimum required steps to move the observer to host2?
Correct Answer: B
Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)
Correct Answer: A,C,D
Which three statements are true about Far Sync instances? (Choose three.)
Correct Answer: A,D,E
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method? (Choose three.)
Correct Answer: A,B,D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
On your logical standby database, you specified these rules:
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_NEW');
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_OLD');
After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:
SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP%');
Which is true regarding the execution of the UNSKIP procedure?
Correct Answer: E
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which three are prerequisites for enabling Fast-Start Failover? (Choose three.)
Correct Answer: B,E,F
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)
Correct Answer: B,E,F
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control.
Which two are true about this change? (Choose two.)
Correct Answer: A,C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)
Correct Answer: B,E
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
0
0
0
0