1Z0-076 Free Sample Questions

A financial services company has a Data Guard configuration with a primary database in New York and a physical standby in London. To meet regulatory requirements for zero data loss (RPO=0) over this high-latency WAN link, a Far Sync instance has been deployed in a data center halfway between the sites. During a network outage, the primary database can no longer communicate with the Far Sync instance. What is the expected behavior of the primary database if the configuration is in Maximum Availability mode?

A DBA is configuring Fast-Start Failover (FSFO) and wants to ensure that an automatic failover does not occur during brief, transient network glitches between the primary and the observer. Which TWO DGMGRL properties should be configured to control this behavior? (Select TWO)

A database architect is designing a Data Guard solution for a large e-commerce platform. The primary database experiences extremely high transaction rates. The architect needs to minimize the performance impact on the primary database caused by redo transport. Which redo transport parameter, when configured, can significantly improve throughput by bundling redo data from multiple log writer (LGWR) sessions into a single network I/O?

True or False: When a physical standby database is converted to a snapshot standby, it stops receiving redo data from the primary database until it is converted back to a physical standby.

A DBA needs to reinstate a failed primary database after a Fast-Start Failover. The DBA has confirmed that Flashback Database was enabled on the old primary. The DBA issues the `REINSTATE DATABASE 'old_primary'` command in DGMGRL. What is the first major action the Data Guard Broker performs on the old primary database as part of this command?

A system administrator is using RMAN to create a physical standby database from an active primary. The administrator wants to place the standby's data files in `/u02/oradata/BOSTON/` while the primary's files are in `/u01/oradata/CHICAGO/`. Which parameter must be set in the standby's initialization parameter file for the RMAN `DUPLICATE` command to handle this file renaming automatically?

A Data Guard Broker configuration is in Maximum Availability mode. A DBA performs a graceful shutdown of the primary database using `SHUTDOWN IMMEDIATE`. What is the expected status of the Data Guard configuration as reported by the Broker?

A DBA is managing a logical standby database and needs to prevent DDL changes made to the `HR.EMPLOYEES` table on the primary from being applied to the standby. However, all DML changes (INSERT, UPDATE, DELETE) to this table should still be applied. Which `DBMS_LOGSTDBY` procedure should be used to achieve this specific requirement?

A retail company uses an Active Data Guard physical standby for running real-time sales reports. The primary database is heavily loaded. To reduce network traffic and CPU overhead on the primary, the administrator wants to enable redo transport compression. This compression must only be active for the connection to the reporting standby, not to another standby used for disaster recovery. How can this be achieved?

True or False: The `VALIDATE DATABASE` command in DGMGRL can be used to verify that standby redo logs are correctly configured on both the primary and standby databases.