Free Oracle 1Z0-066 Exam Dumps Questions & Answers

Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)

• A.  The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
• B.  Database properties may be modified when that database is disabled from broker management.
• C.  The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
• D.  A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
• E.  The configuration transport mode may be modified while the entire configuration is disabled from broker management.

Which four factors can influence the rate of SQL apply on a logical standby database? (Choose four.)

• A.  the number of full table scans performed by SQL apply
• B.  the number of coordinator processes on the standby database instance
• C.  the number of APPLIER processes
• D.  the size of the undo tablespace on the logical standby database
• E.  the number of PREPARER processes
• F.  the size of the shared pool

Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database? (Choose two.)

• A.  The logical standby database must have Real-Time Query enabled.
• B.  There must be connectivity between the primary and the physical standby database.
• C.  FLASHBACK DATABASE must be enabled on the physical standby database.
• D.  FLASHBACK DATABASE must be enabled on the primary database.
• E.  The physical standby database must have Real-Time Apply enabled.

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

Which three are always benefits of using a logical standby database? (Choose three.)

• A.  It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
• B.  It can be used for reporting workloads requiring additional indexes or materialized views or both.
• C.  It can be used for testing patchsets without affecting the primary database.
• D.  It can be used for database rolling release upgrades.
• E.  It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.
• F.  It can be used to replicate a single pluggable database (PDB) in a multitenant container database.