Free Oracle 1z0-076 Exam Dumps Questions & Answers

You have a Data Guard Broker configuration called 'Somewhere' as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration - Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby - Primary database
FS - Far Sync
Farout - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE 'Nearby' 'InconsistentProperties';
Which two are true about the output of this DGMGRL command?

• A.Any inconsistency reported is on an instance-specific basis.
• B.It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
• C.It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.
• D.A far sync instance cannot have inconsistent properties because it has no database.

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

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

Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to sync
4. Real-time query is enabled for both standby databases
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

• A.Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.
• B.Decrease the redo log file size on the primary database.
• C.Increase the size of the buffer cache on the physical standby database instances.
• D.Increase the size of standby redo log files on the standby databases.
• E.Increase the number of standby redo log files on the standby databases.

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

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

A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?

• A.A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing
• B.A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing
• C.These requirements cannot be met.
• D.A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing