Oracle 1Z0-447 Online Practice Questions and Exam Preparation

Oracle 1Z0-447 Online Questions & Answers

• Question 1:

  Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

  A. Run the chkpt_db_extracttrail.sql script.
  B. Run the chkpt_db_create.sql script.
  C. Use the ADD Extract Trail command.
  D. Use the INFO REPLICAT command with the SHOWCH option.
  E. Use the ADD CHECKPOINTTABLE command.
  B. Run the chkpt_db_create.sql script.
  E. Use the ADD CHECKPOINTTABLE command.

  ---

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

• Question 2:

  You want to eliminate the reporting output from processing a Macro. How should you proceed?

  A. Use the optional parameter NOLIST.
  B. Use the optional parameter UNLIST.
  C. Use the optional parameter NOREPORT.
  D. Use the optional parameter NOMACROOUTPUT.
  A. Use the optional parameter NOLIST.

  ---

  Reference: http://www.ateam-oracle.com/oracle-goldengate-using-macros/

• Question 3:

  You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH. How should you proceed?

  A. Use the Read Startup Checkpoint.
  B. Use the Read Recovery Checkpoint.
  C. Use the Write Startup Checkpoint.
  D. Use the Read Current Checkpoint.
  B. Use the Read Recovery Checkpoint.

  ---

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

• Question 4:

  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.
  B. Use the SHARE option of the REGISTER EXTRACT command.

• Question 5:

  You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

  A. Tables set with nologging
  B. Tables with Large Object (LOB) data types
  C. Tables that have conflicts
  D. Triggers and sequences
  C. Tables that have conflicts

• Question 6:

  You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works?

  A. The Replicat with the FORMAT RELEASE parameter.
  B. The Extract with the FORMAT RELEASE parameter.
  C. The Extract to write directly to the remote trail.
  D. The collector with the FORMAT RELEASE parameter.
  A. The Replicat with the FORMAT RELEASE parameter.

• Question 7:

  Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

  A. The GGSCI session was configured incorrectly.
  B. The Manager parameter file contains SYSLOG ALL.
  C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.
  D. The user session running Manager is set to log all messages.
  C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

  ---

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

• Question 8:

  What sequence of steps should you follow to add a data pump that reads from a local trail?

  A. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, TRAILSOURCE trail name.
  B. In GGSCI, on the source system, issue the command: ADD PUMP group name, TRAILSOURCE trail name.
  C. In GGSCI, on the source system, issue the command: ADD PUMP group name, EXTTRAILSOURCE trail name.
  D. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name.
  D. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name.

  ---

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIINF/giinf_add_processes.htm#GIINF304

• Question 9:

  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.
  D. Use the WARNRATE parameter to set the threshold.

  ---

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

• Question 10:

  You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

  A. It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
  B. It is caused by the thread with the highest thread ID applying barrier transactions.
  C. It is caused by the use of the MAXTRANSOPS parameter.
  D. It is caused by barrier transactions in a Coordinated Replicat.
  D. It is caused by barrier transactions in a Coordinated Replicat.

  ---

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