1z0-066 Sample Questions

1z0-066 Sample Questions & Answers

Free Oracle Database 12c: Data Guard Administration practice questions with worked answers and explanations. See how the ExamJungle simulator prepares you — then jump into the full test.

Launch the full 1z0-066 simulator →

Showing 6 of 12 free samples.

  1. Question 1Select 2

    Examine the Data Guard configuration:

    DGMGRL) show configuration;

    Configuration-Animals

    Protection Mode: MaxAvailability

    Databases:
    dogs - Primary database
    dogsfs1 - Far Syncs
    heep - Physical standby database

    Fast-Start Failover: DISABLED

    Configuration Status:
    SUCCESS

    An attempt to enable fast-start failover raises an error:
    DGMGRL> enable fast_start failover;
    Error: ORA-16693: requirements not metfor enabling fast-startfailover
    Failed.

    Identify two possible reasons for this error. (Choose two.)

    Show answer & explanation

    Correct answers: A, D

    A, D -- Explanation: D: Ensure that the LogXptMode property for both the primary database and the Fast-Start Failover target standby database are SYNC.A: If more than one physical or logical standby database exists, in this case it is the sheep database, you must specify the FastStartFailoverTarget value explicitly, prior to enabling fast-start failover. The indicated target is verified when fast-start failover is enabled.
    Note: DGMGRL) enablefast_startfailover;Error: ORA-16651: requirements not metfor enabling fast-startfailoverFailed.
    SOLUTION1) Check whether the flashback database is enabled on primary and standby database Select flashback_on from gv$database;2) Checkwhether you have setthe FastStartFailoverTarget parameter.
    References: docs.oracle.com/cd/E11882_01/server. 112/e40771 /dbpropref.htm#DGBKR862')https://docs.oracle.com/cd/E11882_01/server. 112/e40771 /dbpropref.htm#DGBKR862 psoug.org/oraerror/OR')http://psoug.org/oraerror/ORA-16651.htm

    A, D -- Explanation: D: Ensure that the LogXptMode property for both the primary database and the Fast-Start Failover target standby database are SYNC.A: If more than one physical or logical standby database exists, in this case it is the sheep database, you must specify the FastStartFailoverTarget value explicitly, prior to enabling fast-start failover. The indicated target is verified when fast-start failover is enabled.
    Note: DGMGRL) enablefast_startfailover;Error: ORA-16651: requirements not metfor enabling fast-startfailoverFailed.
    SOLUTION1) Check whether the flashback database is enabled on primary and standby database Select flashback_on from gv$database;2) Checkwhether you have setthe FastStartFailoverTarget parameter.
    References: docs.oracle.com/cd/E11882_01/server. 112/e40771 /dbpropref.htm#DGBKR862')https://docs.oracle.com/cd/E11882_01/server. 112/e40771 /dbpropref.htm#DGBKR862 psoug.org/oraerror/OR')http://psoug.org/oraerror/ORA-16651.htm

  2. Question 2Select 2

    You are licensed to use Oracle Active Data Guard.
    Which two statements are true after enabling block change tracking on a physical standby database? (Choose two.)

    Show answer & explanation

    Correct answers: A, B

    A, B -- Explanation:
    A: Many of the customers now are opting to perform RMAN backups on standby database to offload the resources of production database.
    B: To enable Active Data Guard on a standby database, set the ENABLE_CPTIDN_ACTIVE_DATA_GUARD initialization parameter to TRUE.
    Note: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration but it is limited only for Primary database. From 11g Grade with Active Data Guard feature we can use Block change tracking even on Physical standby database.
    References: www.morganslibrary.org/reference/block_ch')http://www.morganslibrary.org/reference/block_change_tracking.html

    A, B -- Explanation:
    A: Many of the customers now are opting to perform RMAN backups on standby database to offload the resources of production database.
    B: To enable Active Data Guard on a standby database, set the ENABLE_CPTIDN_ACTIVE_DATA_GUARD initialization parameter to TRUE.
    Note: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration but it is limited only for Primary database. From 11g Grade with Active Data Guard feature we can use Block change tracking even on Physical standby database.
    References: www.morganslibrary.org/reference/block_ch')http://www.morganslibrary.org/reference/block_change_tracking.html

  3. Question 3Select 2

    A Data Guard environment has this configuration and these attributes:

    1. A primary database
    2. A Physical Standby Database named sbdb
    3. The configuration is in maximum availability protection mode.

    Then sbdb is converted to a snapshot standby database.

    When two statements are true? (Choose two.)

    Show answer & explanation

    Correct answers: D, E

    D, E -- Explanation: E: A snapshot standby database receives and archives, but does not apply, redo data from a primary database.
    D: Snapshot standby databases are best used in scenarios where the benefit of having a temporary, updatable snapshot of the primary databasejustifies additional administrative complexity and increased time to recover from primary database failures.
    Note: Redo data received from the primary database is applied when a snapshot standby database is converted back into a physical standby database, after discarding all local updates to the snapshot standby database.
    The data in the primary database is fully protected however, because a snapshot standby can be converted back into a physical standby database at any time, and the redo data received from the primary will then be applied. Incorrect answers:A: snapshot standby database receives and archives, but does not apply, redo data from a primary database.
    References: https://docs.oracle.com/cd/B28359 Q1/server.111/b28294/manage ps.htm

    D, E -- Explanation: E: A snapshot standby database receives and archives, but does not apply, redo data from a primary database.
    D: Snapshot standby databases are best used in scenarios where the benefit of having a temporary, updatable snapshot of the primary databasejustifies additional administrative complexity and increased time to recover from primary database failures.
    Note: Redo data received from the primary database is applied when a snapshot standby database is converted back into a physical standby database, after discarding all local updates to the snapshot standby database.
    The data in the primary database is fully protected however, because a snapshot standby can be converted back into a physical standby database at any time, and the redo data received from the primary will then be applied. Incorrect answers:A: snapshot standby database receives and archives, but does not apply, redo data from a primary database.
    References: https://docs.oracle.com/cd/B28359 Q1/server.111/b28294/manage ps.htm

  4. Question 4

    You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:

    1. Data loss is not permitted.
    2. Read-only applications should not connectto the primary database instance.
      Additionally, there are these requirements, only one ofwhich is ever done at any one time:
    3. It should be possible to apply and test designated patches with a minimum amount of downtime.
    4. Upgrading to a new database release should be performed with the least possible amount of downtime.
    5. New application software releases should be tested against an exact up-to-date replica of the production database.
      You propose a primary database with one physical standby database configured in Maximum Protection mode.
      Which requirements do you meet?
    Show answer & explanation

    Correct answer: C

    Explanation:
    Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
    Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum oftwo standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down.
    Incorrect answers:
    A: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
    -- Reference: https://docs.oracle.eom/cd/B28359 01/server.111/b28294/protection.htm

  5. Question 5Select 2

    A customer asks you to propose the most appropriate solution for this set of requirements:

    1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
    2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
    3. Developers may need to test occasionally on a copy of the live database.
      You have already confirmed thatthere are no unsupported data types on the primary database.
      Which two solutions would you recommend? (Choose two.)
    Show answer & explanation

    Correct answers: B, C

    B, C

    B, C

  6. Question 6Select 3

    Which three are true aboutthe rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)

    Show answer & explanation

    Correct answers: B, D, E

    B, D, E

    B, D, E

    B, D, E

Ready for the real thing?

The full 1z0-066 simulator has every exam-style question, timed mode, and instant scoring.

Go to the 1z0-066 simulator →