1Z0-066 by Oracle Valid Free Exam Practice Test

Question 1

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. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby. C. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host. D. 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.

Correct Answer: D

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

Question 2

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. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration. D. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

Correct Answer: B

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

Question 3

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. SYNC AFFIRM and Maximum Protection C. SYNC AFFIRM and Maximum Availability D. ASYNC and Maximum Performance E. SYNC NOAFFIRM and Maximum Availability

Correct Answer: C

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

Question 4

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. Cats is a bystander database. B. The observer is not running, but should run on ol7.example.com. C. The observer is connected to the database on which the query was executed. D. The observer is currently running on ol7.example.com. E. The observer is not connected to the database on which the query was executed.

Correct Answer: E

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

Question 5

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

A. a physical standby database with real-time query enabled B. a snapshot standby database with synchronous redo transport C. a remote physical standby database with RedoRoutes via a far sync instance D. a logical standby database E. a read mostly implementation of a physical standby database

Correct Answer: A,B

Question 6

In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control? (Choose two.)

A. A logical standby database is the only standby database in the data guard configuration. B. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode. C. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration. D. A snapshot standby database is the only standby database in the Data Guard configuration. E. The primary and standby databases are hosted on different operating systems.

Correct Answer: A,E

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

Question 7

Examine the Data Guard configuration:
DGMGRL > show configuration:
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
cats Snapshot standby database
sheep Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats? (Choose three.)

A. Sheep will be in the enabled state. B. Dogs will be in the disabled state and has to be manually reinstated. C. The configuration will be in Maximum Performance mode. D. The configuration will be in Maximum Availability mode. E. Sheep will be in the disabled state.

Correct Answer: A,B,C

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