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

Question 1

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 2

Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)

A. A logical standby database chooses an appropriate location for writing its own standby archive logs automatically. B. A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote physical standby database instance to which it routes redo, is not reachable. C. A logical standby database instance writes online redo logs. D. A physical standby database instance writes online redo logs. E. A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically. F. A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote logical standby database instance to which it routes redo, is not reachable.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 3

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)

A. A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled. B. DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery. C. When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files. D. DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery. E. When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question 4

Which two are true about management of a far sync instance when using the Data Guard Broker? (Choose two.)

A. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created. B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration. C. A far sync instance is in a disabled state in the broker configuration immediately after adding it. D. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question 5

Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)

A. It enables the use of far sync instances. B. It permits a primary database that was disabled after failover to be reinstated as a standby. C. It is required in order for a snapshot standby database to be converted to a physical database. D. It is a prerequisite for the use of Fast Start Failover. E. It permits a physical standby database to be converted to a snapshot standby database.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question 6

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

A. 1, 2, 3, 4, and 5 B. 1 and 2 C. only requirement 1 D. 2, 3, 4, and 5 E. only requirement 5

Discussion 0

Correct Answer: B Vote an answer

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

Question 7

Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database? (Choose two.)

A. There must be connectivity between the primary and the physical standby database. B. FLASHBACK DATABASE must be enabled on the primary database. C. FLASHBACK DATABASE must be enabled on the physical standby database. D. The logical standby database must have Real-Time Query enabled. E. The physical standby database must have Real-Time Apply enabled.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question 8

After converting your physical standby database to a logical database, you get an error:
DGMGRL> show configuration
Configuration proddg
Protection Mode: MaxPerformance
Databases:
prod Primary database
prodsby Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?

A. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it. B. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata. C. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration. D. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

Discussion 0

Correct Answer: B Vote an answer

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

Question 9

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
------------------ --------------------------
BYSTANDER cats
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------------------------- -------------------------
NO ol7.example.com
Which are true?

A. The observer is connected to the database on which the query was executed. B. The observer is currently running on ol7.example.com. C. Cats is a bystander database. D. The observer is not running, but should run on ol7.example.com. E. The observer is not connected to the database on which the query was executed.

Discussion 0

Correct Answer: E Vote an answer

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