1. Home
  2. Oracle
  3. 1Z0-447

Oracle 1Z0-447 Online Practice Questions and Exam Preparation

1Z0-447 Exam Details

  • Exam Code
    :1Z0-447
  • Exam Name
    :Oracle GoldenGate 12c Implementation Essentials
  • Certification
    :Oracle Certifications
  • Vendor
    :Oracle
  • Total Questions
    :81 Q&As
  • Last Updated
    :Jan 14, 2026

Oracle 1Z0-447 Online Questions & Answers

  • Question 1:

    Which transactions are captured if you ADD EXTRACT with BEGIN NOW at 1:00 PM, START EXTRACT at 2:00 PM?

    A. Transactions that started at or after 1:00 PM
    B. Transactions that started before 1:00 PM and committed after 2:00 PM
    C. Only transactions that started before 1:00 PM and committed after 1:00 PM
    D. Only transactions that started at or after 2:00 PM

  • Question 2:

    Which three statements are true regarding GoldenGate password encryption? (Choose three.)

    A. An encrypted password cannot be generated using a user-defined key
    B. An encrypted password can be generated using the default key
    C. An encrypted password can be generated using a user-defined key
    D. A password cannot be encrypted and pasted into a parameter file
    E. A password can be encrypted and pasted into a parameter file

  • Question 3:

    Which three are requirements to correctly configure an OGG trail file? (Choose three.)

    A. a trail file identifier
    B. designation as local or remote
    C. a maximum file size
    D. an Extract process
    E. a Replicat process

  • Question 4:

    Because SQL errors are filling the Replicat report file, you want to set a threshold for the number of errors that can be tolerated on any target table before being reported to the process report and to the error log.

    How can you accomplish this?

    A. Use the REPORTCOUNT parameter to set the threshold.
    B. Use the STATS parameter to set the threshold.
    C. Use the ERRORTHRESHOLD parameter to set the threshold.
    D. Use the WARNRATE parameter to set the threshold.

  • Question 5:

    Which capability does GoldenGate support?

    A. file-based Capture
    B. asynchronous Capture and Delivery of committed DML transactions
    C. two-phase commit operations from application interfaces
    D. Synchronous transaction Capture from application interfaces

  • Question 6:

    What is a valid net result for an Extract configured with the following parameters in this order: getinserts, getupdatebefores, ignoredeletes, ignoreupdates?

    A. Inserts, updates, and deletes will be captured.
    B. Before and after images of updates will be ignored.
    C. Inserts and deletes will be captured.
    D. Before and after images of updates will be captured.

  • Question 7:

    You want to map exception to an exceptions table using the MAPEXCEPTION option of the MAP parameter. When should you proceed?

    A. when the names of both the source and target tables in the MAP statement are wildcarded
    B. when there is a unique restriction on the exception table
    C. when there is a primary key on the exception table
    D. when there is a failed operation logged on the source table

  • Question 8:

    Which other character, besides the COMMENT parameter, can you use to enter remarks in a parameter file? A.\\

    B. //
    C. -
    D. \*

  • Question 9:

    You want to reduce an Integrated Extract's startup time by using an existing data dictionary. How should you accomplish this?

    A. Set the shared memory realm of an Integrated Extract with other Integrated Extracts.
    B. Use the SHARE option of the REGISTER EXTRACT command.
    C. Share the registration ID with other Integrated Extracts.
    D. Begin the Extract processing at the earliest SCN of the log stream.

  • Question 10:

    You need to manually patch Oracle GoldenGate source and targets. How should you proceed?

    A. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. If the patches changed table definitions, run DEFGEN for the source tables to generate updated source definitions, and then replace the old definitions with the new ones in the existing source definitions file on the target system. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
    B. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
    C. Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
    D. Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-447 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.