1z0-447

1z0-447 practice questions, page 3 of 4, with answer review and explanations.

Question 11

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

  1. The incorrect version of GoldenGate was installed for your CPU architecture.
  2. A license key must be applied first.
  3. GoldenGate Manager was not started first.
  4. The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.

Question 12

Identify the correct statement regarding Trails.

  1. Extract and Pump are different OS level executable binary files.
  2. Extracts cannot perform filtering, mapping, and transformations.
  3. RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
  4. Extract is typically used to produce local trail files over a TCP/IP connection.

Question 13

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

  1. Run the chkpt_db_extracttrail.sql script.
  2. Run the chkpt_db_create.sql script.
  3. Use the ADD Extract Trail command.
  4. Use the INFO REPLICAT command with the SHOWCH option.
  5. Use the ADD CHECKPOINTTABLE command.

Question 14

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

  1. Configure Replicat with the FORMATASCII SQLLOADER OPTION.
  2. Configure Extract with the FORMATSQL SQLLOADER OPTION.
  3. Configure Extract with the FORMATASCII SQLLOADER OPTION.
  4. Configure Replicat with the FORMATXML OPTION.

Question 15

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?

  1. Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
  2. Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  3. Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  4. Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.