Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 1:

  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

  Correct Answer: ABD

• 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

  Correct Answer: BCE

• Question 3:

  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

  Correct Answer: A

• Question 4:

  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.

  Correct Answer: D

• 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

  Correct Answer: B

• Question 6:

  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.

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_monitoring.htm#GWUAD645

• Question 7:

  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.

  Correct Answer: B

• Question 8:

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

  A. \\

  B. //

  C. -

  D. \*

  Correct Answer: C

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ gg_parameters027.htm#GWURF426

• Question 9:

  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

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/ wu_errorhandling.htm#GWUAD502

• 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.

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_adminops.htm#GWUAD701