Want to pass your Oracle Database 12c: Data Guard Administrator 1Z0-066 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
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 AFFIRM and Maximum Protection
B. SYNC NOAFFIRM and Maximum Protection
C. SYNC AFFIRM and Maximum Availability
D. SYNC NOAFFIRM and Maximum Availability
E. ASYNC and Maximum Performance
Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?
A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host
Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
A. Ensure that no ROWID data types are contained in the primary database.
B. Ensure that flashback is enabled on the primary database.
C. Ensure that supplemental logging is enabled on the primary database.
D. Do not perform any nologging operations on the primary.
E. Ensure that no BFILE LOB data types are contained in the primary database.