Free Oracle 1Z0-066 Exam Dumps Questions & Answers

Which two statements are true about Real-Time Query? (Choose two.)

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

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.The configuration will be in Maximum Performance mode.
• B.Sheep will be in the disabled state.
• C.The configuration will be in Maximum Availability mode.
• D.Dogs will be in the disabled state and has to be manually reinstated.
• E.Sheep will be in the enabled state.

Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?

• A.FLASHBACK is automatically enabled when transitioning to the logical standby database.
• B.It will automatically start redo apply.
• C.The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
• D.Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
• E.SQL apply is automatically started when transitioning to the logical standby database.

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)

• A.Create an SPFILE for the standby database.
• B.Transfer a copy of the passwordfile from the primary host to the standby host.
• C.Run the nid utility to modify the DBID of the primary database.
• D.Create a standby controlfile.
• E.Configure Oracle Net connectivity between the primary host and the standby host.

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

• A.SYNC NOAFFIRM and Maximum Protection
• B.ASYNC and Maximum Performance
• C.SYNC AFFIRM and Maximum Protection
• D.SYNC NOAFFIRM and Maximum Availability
• E.SYNC AFFIRM and Maximum Availability