Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-066

Free Oracle 1Z0-066 Exam Braindumps (page: 2)

Page 2 of 47
PDF with 184 Questions

Which two statements are true about Real-Time Query?

  1. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.
  2. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
  3. Real-Time Query sessions can be connected to a Far Sync instance.
  4. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
  5. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Answer(s): B,D



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

  1. They are required on a logical standby for real-time apply
  2. They are required only for synchronous redo transport.
  3. Only standby databases can write redo to them.
  4. It is recommended to have them on the primary database.
  5. They are required on a physical standby for real-time apply.
  6. The LGWR process writes to them on a standby database.

Answer(s): A,C,E



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?





Answer(s): C



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 maxavailability;
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. (Choose two.)

  1. DGMGRL> convert database sheep to physical standby;
  2. DGMGRL> convert database cats to physical standby;
  3. DGMGRL> edit database dogs set property LogXptMode= fastsync;
  4. DGMGRL> edit database sheep set property LogXptMode= fastsync;
  5. DGMGRL> edit database cats set property LogXptMode= sync;

Answer(s): B,E






Post your Comments and Discuss Oracle 1Z0-066 exam prep with other Community members:

1Z0-066 Exam Discussions & Posts