Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 201:

  Examine the Data Guard configuration: DGMGRL > show configuration; Configuration-Animals

  Protection Mode MaxPerformance Databases dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as max availability; Error ORA-16627 operation disallowed since no standby databases would remain to support protection

  mode Failed.

  Identify two statements that you can execute, either one of which will enable successful raising of the

  protection mode to Maximum Availability.

  A. DGMGRL> convert database sheep to physical standby;

  B. DGMGRL> convert database cats to physical standby;

  C. DGMGRL> edit database dogs set property LogXptMode= fastsync;

  D. DGMGRL> edit database sheep set property LogXptMode= fastsync;

  E. DGMGRL> edit database cats set property LogXptMode= sync;

  Correct Answer: BE

• Question 202:

  Which two statements are true about Real-Time Query?

  A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.

  B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.

  C. Real-Time Query sessions can be connected to a Far Sync instance.

  D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

  E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

  Correct Answer: BD

• Question 203:

  Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

  A. They are required on a logical standby for real-time apply

  B. They are required only for synchronous redo transport.

  C. Only standby databases can write redo to them.

  D. It is recommended to have them on the primary database.

  E. They are required on a physical standby for real-time apply.

  F. The LGWR process writes to them on a standby database.

  Correct Answer: ACE

• Question 204:

  Your Data Guard environment has one physical standby database using Real-Time Query.

  Two sentences 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 A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C