Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 51:

  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

  Correct Answer: C

• Question 52:

  If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

  A. Manager

  B. Replicat

  C. Extract

  D. Extract and Replicat

  Correct Answer: A

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

• Question 53:

  What is the key purpose of GoldenGate trail files?

  A. They are a persistent storage area for captured transactions.

  B. They are configuration files for the GoldenGate processes.

  C. They are checkpoint files for the GoldenGate processes.

  D. They are database auditing logs where GoldenGate captures changes.

  Correct Answer: C

• Question 54:

  Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

  A. ENABLE_GOLDENGATE_REPLICATION=true

  B. ENABLE_STREAMS_REPLICATION=true

  C. Configure the STREAMS_POOL_SIZEdatabase parameter

  D. ENABLE_DATABASE_REPLICATION=true

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/setup.htm#GIORA983

• Question 55:

  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 ADDExtract Trail command.

  D. Use the INFOREPLICAT command with the SHOWCH option.

  E. Use the ADDCHECKPOINTTABLEcommand.

  Correct Answer: BE

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

• Question 56:

  You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to–database utility. How should you configure GoldenGate in order to accomplish this?

  A. Configure Replicat with the FORMATASCII SQLLOADER OPTION.

  B. Configure Extract with the FORMATSQL SQLLOADER OPTION.

  C. Configure Extract with the FORMATASCII SQLLOADER OPTION.

  D. Configure Replicat with the FORMATXML OPTION.

  Correct Answer: C

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

• Question 57:

  Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extract has stopped?

  A. Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.

  B. Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.

  C. Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.

  D. Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.

  Correct Answer: C

  Reference: http://www.oracle.com/technetwork/database/features/availability/maa-goldengate-rac2007111.pdf

• Question 58:

  Which statement is valid for DDL replication?

  A. GoldenGate User Exits are not supported for DDL.

  B. Source and target objects can be different.

  C. Target objects can be different from source when using SOURCEDEFS in Replicat.

  D. It can use WILDCARDRESOLVE IMMEDIATE.

  Correct Answer: B

• Question 59:

  You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

  A. The incorrect version of GoldenGate was installed for your CPU architecture.

  B. A license key must be applied first.

  C. GoldenGate Manager was not started first.

  D. The LD_LIBRARY_PATHvariable to $ORACLE_HOME was not set.

  Correct Answer: A

• Question 60:

  Identify the correct statement regarding Trails.

  A. Extract and Pump are different OS level executable binary files.

  B. Extracts cannot perform filtering, mapping, and transformations.

  C. RMTTRAILis for remote trails and EXTTRAILis for local trails.

  D. Extract is typically used to produce local trail files over a TCP/IP connection.

  Correct Answer: B