Online Access Free 1z0-076 Exam Questions

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
ou 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?

• A.None, because you can directly failover to a Snapshot Standby Database.
• B.DGMGRL> convert database cats to physical standby;
• C.DGMGRL> convert database sheep to physical standby;
  DGMGRL> edit configuration set protection mode as maxperformance;
  DGMGRL> convert database sheep to physical standby;
• D.DGMGRL> convert database sheep to physical standby;
• E.DGMGRL> convert database cats to physical standby;

Which three types of backups offload ........ with the primary database in a data Guard

• A.Control files
• B.Broker configuration files
• C.Data files
• D.Password files
• E.Online logs
• F.Archive logs

Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A.If the CACHE option is set then the size of the cache must be at least 100.
• B.They must have the NOORDEK and CACHE options set.
• C.Their usage will always have a performance impact on the primary database.
• D.Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.
• E.Their usage may have a performance impact on the physical standby database if the CACHE size is too small.

A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

• A.A physical standby database with real-time apply enabled
• B.A snapshot standby database with synchronous redo transport
• C.A logical standby database with real-time query enabled
• D.A physical standby database with real-time query enabled
• E.A logical standby database with real-time apply enabled

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

• A.Ensure that no BFILE LOB data types are contained in the primary database.
• B.Ensure that supplemental logging is enabled on the primary database.
• C.Ensure that no ROWID data types are contained in the primary database.
• D.Ensure that flashback is enabled on the primary database.
• E.Do not perform any nologging operations on the primary.