Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 21:

  Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

  A. TARGETDB TargetDSN USERID sampleID PASSWORD samplepword

  B. SOURCEDB SourceDSN

  C. SOURCEDB sampleDB USERID sampleID PASSWORD samplepword

  D. TARGETDB sampleID samplepword

  Correct Answer: B

• Question 22:

  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.

  Correct Answer: C

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

• Question 23:

  You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

  A. Start the Extract task.

  B. Start the Extract task, wait for it to stop, and then start the Replicat task.

  C. Start the Extract task and then start the Replicat task.

  D. Start the Replicat task.

  Correct Answer: C

• Question 24:

  Which method in GoldenGate should you use to undo DML changes previously made to a target database?

  A. Run Extract and Replicat from the command line.

  B. Use Extract and Replicat with the GoldenGate Logdump utility.

  C. Run the Reverse Utility on the target database transaction logs.

  D. Use Extract and Replicat with the GoldenGate Reverse utility.

  Correct Answer: D

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

• Question 25:

  Which two are valid macros?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: AD

• Question 26:

  In which process should you configure the warning for long-running transactions?

  A. Jagent

  B. Extract

  C. Replicat

  D. Manager

  Correct Answer: B

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

• Question 27:

  A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

  A. Use the FILTERoption in the MAP parameter.

  B. Use the COLMAPoption in the MAP parameter.

  C. Do not specify those columns in the ADDTRANDATAcommand.

  D. Use the COLS and COLSEXCEPToptions in the TABLE parameter.

  Correct Answer: B

• Question 28:

  Which GLOBALS parameter is required to initially enable monitoring?

  A. JAGENTMONITORING

  B. ENABLEMONITORING

  C. ENABLEOEMMONITORING

  D. CHECKMONITORING

  Correct Answer: B

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

• Question 29:

  Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

  A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater

  B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater

  C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater

  D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

  Correct Answer: C

• Question 30:

  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.

  Correct Answer: A

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