Online Access Free 1z0-076 Exam Questions

Which TWO statements are true regarding Data Guard Broker?

• A.It can be used to create and manage standby databases.
• B.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
• D.It can be used to perform failovers and switchovers.
• E.It can be used to monitor redo transport and log apply services.

Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
sheep - Primary database
dogs - Logical standby database
cats - Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three statements will be true after a switchover to Dogs?

• A.Cats will be an enabled physical standby database.
• B.Sheep will be an enabled logical standby database.
• C.Sheep will be a disabled logical standby database.
• D.Cats will be a disabled physical standby database that can be manually enabled.
• E.Dogs will be the primary database.

You must configure an Oracle Data..........
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

• A.1, 6, and 7
• B.1, 2, and 5
• C.1, 2, 6, and 7
• D.1, 2, 3, 6, and 7
• E.1, 2, 3, 4, 5, 6, and 7

Which two factors can cause an increase in redo transport lag?

• A.The size of the online redo log files on the standby database.
• B.Increase in redo generation rate on the primary database.
• C.The size of the standby redo log files on the primary database.
• D.The size of the online redo log files on the primary database.
• E.Increase in network latency between the primary database and a redo transport destination.

Examine the fast-start failover configuration:

• A.The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
• B.You must disable fast-start failover first to change the fast-start failover target to East sales.
• C.The observer is running.
• D.A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
• E.If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.