Free Oracle Database 19c: Data Guard Administration Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Oracle Database 19c: Data Guard Administration practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1Which Data Guard service controls the automated transfer of redo from a production database to archival destinations?

   1. A.Redo Transport ServicesCorrect answer: A
   2. B.Apply Services
   3. C.SQL Apply
   4. D.Redo Apply

   Explanation: Oracle states: "Redo transport services control the automated transfer of redo data from the production database to one or more archival destinations." This supports the selected answer under the stated conditions.

   Reference: Introduction to Oracle Data Guard — 1.2.1 Redo Transport Services

2. 2Why does Oracle recommend configuring the original primary database to receive redo when adding its first standby?

   1. A.To apply redo while the original primary remains open as primary.
   2. B.To send redo to standbys without configuring any destinations.
   3. C.To eliminate the need for standby redo logs after a role change.
   4. D.To receive redo promptly after the original primary becomes a standby.Correct answer: D

   Explanation: Oracle states: "The primary database can then quickly transition to the standby role and begin receiving redo data, if necessary." This establishes the answer for the configuration described.

   Reference: Creating a Physical Standby Database — 3.1.3 Configure the Primary Database to Receive Redo Data

3. 3Before converting a physical standby to a snapshot standby using SQL, which state must the database be in?

   1. A.Open read-only with Redo Apply active
   2. B.Open read/write with Flashback Database enabled
   3. C.Mounted with Redo Apply active
   4. D.Mounted but not open, with Redo Apply stoppedCorrect answer: D

   Explanation: Oracle states: "Stop Redo Apply, if it is active. Ensure that the database is mounted, but not open." This supports the answer for the described standby.

   Reference: Managing Physical and Snapshot Standby Databases — 10.11.1 Converting a Physical Standby Database into a Snapshot Standby Database

4. 4How does the Data Guard broker manage members of a Data Guard configuration?

   1. A.It groups members logically and manages them as one configuration.Correct answer: A
   2. B.It manages only the primary, leaving all standbys outside the configuration.
   3. C.It manages each standby in a separate configuration without a primary.
   4. D.It monitors members individually but cannot coordinate configuration operations.

   Explanation: Oracle states: "The Oracle Data Guard broker logically groups these members into a broker configuration that allows the broker to manage and monitor them together as an integrated unit." This supports the selected answer.

   Reference: Oracle Data Guard Broker Concepts — Oracle Data Guard Configurations and Broker Configurations

5. 5A DBA wants to inspect redo transport and apply behavior visually in Cloud Control. Which Data Guard interface element serves that monitoring task?

   1. A.Performance tools and graphsCorrect answer: A
   2. B.The Add Standby Database wizard
   3. C.Database property pages
   4. D.The Cloud Control switchover operation

   Explanation: Oracle states: "Performance tools and graphs that help you monitor and tune redo transport services and log apply services." This supports the selected action.

   Reference: Oracle Data Guard Broker Concepts — Oracle Enterprise Manager Cloud Control

6. 6Which V$DATABASE column shows a database's current Data Guard role?

   1. A.DATABASE_ROLECorrect answer: A
   2. B.OPEN_MODE
   3. C.PROTECTION_MODE
   4. D.SWITCHOVER_STATUS

   Explanation: Oracle states: "To see the current role of the databases, query the DATABASE_ROLE column in the V$DATABASE view." This supports the answer under the stated conditions.

   Reference: Role Transitions — 9 Role Transitions

7. 7What happens in fast-start failover observe-only mode when failover conditions are met?

   1. A.The broker performs automatic failover and changes the primary role.
   2. B.The broker logs that failover would have been initiated without changing the configuration.Correct answer: B
   3. C.The broker waits for a manual failover before recording any condition.
   4. D.The observer logs the condition only after it has promoted the target.

   Explanation: Oracle states: "In this mode, no actual changes are made to your Broker configuration. When the conditions for fast-start failover are met, the Broker adds messages to the observer log and broker log indicating that fast-start failover would have been initiated." Observe-only records the event rather than promoting the standby.

   Reference: Switchover and Failover Operations — Configuring Fast-Start Failover in Observe-only Mode

8. 8Before upgrading, a physical standby has invalid blocks caused by a primary NOLOGGING operation. Which RMAN action can repair those blocks?

   1. A.Recover the nonlogged blocks using changed blocks from the primary.Correct answer: A
   2. B.Apply only the incomplete redo records without fetching data blocks.
   3. C.Copy the standby's invalid blocks back to the primary.
   4. D.Mark the affected standby blocks as logged without restoring them.

   Explanation: Oracle states: "Use the RMAN command RECOVER ... NONLOGGED BLOCK to replace the invalid blocks on the standby with the changed blocks from the primary." This repairs the missing standby blocks before the upgrade.

   Reference: Managing Physical and Snapshot Standby Databases — 10.3 Primary Database Changes That Require Manual Intervention at a Physical Standby

9. 9A new data file, rather than a copy of an existing file, is created on the primary. What happens on a physical standby with STANDBY_FILE_MANAGEMENT=AUTO?

   1. A.The new data file is automatically created on the standby.Correct answer: A
   2. B.The new data file must always be copied manually to the standby.
   3. C.The new data file is created on the standby only after switchover.
   4. D.The new data file is created on the standby only after switching to MANUAL.

   Explanation: Oracle states: "If the STANDBY_FILE_MANAGEMENT database parameter on the physical standby database is set to AUTO, any new data files created on the primary database are automatically created on the physical standby database." This determines the action for the stated change.

   Reference: Managing Physical and Snapshot Standby Databases — 10.3.1 Adding a Data File or Creating a Tablespace

10. 10A Data Guard configuration has primary P and two standbys, S1 and S2. Following Oracle's connect-time failover approach for Fast Connection Failover, which addresses should the descriptor's address list contain?

    1. A.P and S1 only
    2. B.P, S1, and S2Correct answer: B
    3. C.P and S2 only
    4. D.S1 and S2 only

    Explanation: Oracle states: "Configure the connect descriptor for connect-time failover. Add the primary database and each standby database to the address list." This supports the selected configuration.

    Reference: Switchover and Failover Operations — Database Client Considerations, Oracle Net Configuration Requirements