Oracle Database 12c: Data Guard Administrator - 1Z0-066 Free Exam Questions

QUESTION NO: 1
You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:
1. The performance impact on the primary database should be kept to a minimum.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only the one of which is ever done at any one time:
3. It should be possible to apply 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 configuration operating in Maximum Performance mode with a primary database and one logical standby database.
Which requirements do you meet?

Correct Answer: B Vote an answer
QUESTION NO: 2
Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)

Correct Answer: C,E Vote an answer
QUESTION NO: 3
Which three factors can influence the rate of redo apply on a physical standby database? (Choose three.)

Correct Answer: A,B,C Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 4
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

Correct Answer: A,D,E Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 5
Which two Data Guard features require the use of flashback database by the broker? (Choose two.)

Correct Answer: A,E Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 6
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: B Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 7
You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database? (Choose two.)

Correct Answer: C,F Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
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
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

Correct Answer: C Vote an answer

QUALITY AND VALUE

Actual4test Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.

Tested and Approved

We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.

Easy to Pass

If you prepare for the exams using our Actual4test testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.

Try Before Buy

Actual4test offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.