Oracle Database 12c: Data Guard Administrator - 1Z1-066 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

A. A Snapshot Standby Database can be a fast-start failover target. B. A Physical Standby Database can be converted into a Logical Standby Database. C. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade. D. A Logical Standby Database can cascade redo to a terminal destination. E. A Logical Standby Database can be converted to a Snapshot Standby Database.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question 2

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

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

Discussion 0

Correct Answer: D Vote an answer

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

Question 3

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?

A. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name. B. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name. C. Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name. D. Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

Discussion 0

Correct Answer: C Vote an answer

Question 4

You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration? (Choose three.)

A. Archive logs on the primary database may be deleted once they are applied on all standby databases. B. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database. C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases. D. Archive logs on the primary database may be deleted once they are shipped on all standby databases. E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 5

Which three are true about using Flashback database through role transitions in a Data Guard environment?
(Choose three.)

A. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby. B. Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical standby. C. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby. D. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby. E. Flashback database may not be used to undo a physical standby database activation.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 6

Your Data Guard environment has one physical standby database using Real-Time Query.
Two sequences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: B Vote an answer

Question 7

Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

A. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database. B. An automatic failover will be initiated even if the target standby database lags behind the primary. C. The observer is running. D. The configuration operates in Maximum Performance mode. E. The configuration operates in Maximum Availability mode. F. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

Discussion 0

Correct Answer: C,E,F Vote an answer

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

Question 8

Which four factors can influence the rate of SQL apply on a logical standby database? (Choose four.)

A. the number of PREPARER processes B. the number of APPLIER processes C. the size of the undo tablespace on the logical standby database D. the number of coordinator processes on the standby database instance E. the size of the shared pool F. the number of full table scans performed by SQL apply

Discussion 0

Correct Answer: A,B,E,F Vote an answer

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

Question 9

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.
All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.
Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state? (Choose three.)

A. Restart the redo apply. B. Stop the redo apply. C. Recover the database by using the RMAN RECOVER DATABASE command. D. Restore the datafile by using the RMAN RESTORE DATAFILE command. E. Recover the datafile by using the RMAN RECOVER DATAFILE command

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 10

You have a Data Guard broker configuration consisting of:
1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

A. Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored. B. Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored. C. Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored. D. Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored. E. Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

Discussion 0

Correct Answer: D Vote an answer