Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 1:

  What is the GoldenGate command line interface?

  A. SQLCUI
  B. GGSCI
  C. GGCTRL
  D. GGCUI
  B. GGSCI

• Question 2:

  To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS

  A. Will business logic be lost if transaction boundaries are changed?
  B. Will a large number of small commits perform better than a smaller number of large commits?
  C. Will redo buffer size on the target database be adequate for the commit size?
  D. Will the sequence of operations be affected by changing transaction boundaries?
  D. Will the sequence of operations be affected by changing transaction boundaries?

  ---

  In reference guide, page 238: "Limitations of useYou should have a valid business case for using MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to alter the transactional integrity that isimposed by the boundaries that are defined by the source application, even though Replicatapplies the operations in the correct order."

• Question 3:

  Replicat is responsible for which three options?

  A. Reading data out of the GoldenGate trails.
  B. Performing data flow filtering.
  C. Performing data transformations.
  D. Check pointing the oldest uncommitted transaction.
  A. Reading data out of the GoldenGate trails.
  B. Performing data flow filtering.
  C. Performing data transformations.

• Question 4:

  Which process (es) maintain a checkpoint file?

  A. Extract only
  B. Replicat only
  C. Both Extract and Replicat
  D. Server collector
  C. Both Extract and Replicat

  ---

  Reference: http://dbmentors.blogspot.com/2010/12/oracle-goldengate-tutorial-part-1.html

• Question 5:

  When implementing GoldenGate on a 11gR2 Oracle database and after running the GoldenGate Database profiling script, you discover that certain objects are compressed, what should you do?

  A. Contact Oracle support
  B. Continue the implementation of OGG and exclude those objects from replication
  C. Configure OGG with Classic Capture
  D. Configure OGG with Integrated Capture
  D. Configure OGG with Integrated Capture

• Question 6:

  Where is user token data stored?

  A. Trail file
  B. Parameter file
  C. Discord file
  D. Report file
  A. Trail file

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 7:

  When would you use the PASSTHRU parameter?

  A. When using a data pump to distribute all of the trail data "as is" to a remote system.
  B. When Extract is processing database transaction logs where you have a remote database connection.
  C. For a SPECIALRUN one-time processing task that is doing an initial load.
  D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.
  A. When using a data pump to distribute all of the trail data "as is" to a remote system.

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 8:

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

  A. Manager
  B. Extract
  C. Replicat
  D. Both Extract and Replicat
  A. Manager

  ---

  In reference guide, page 256, and I quote "If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all GoldenGate configurations because it allows you to manage trail files in a centralized fashion."

• Question 9:

  What us expected behavior of CHEKPARMS parameter?

  A. The process checks the parameter syntax and then starts running.
  B. The process checks the parameter syntax and then stops.
  C. A report file is created listing all missing parameters.
  D. A report file is created listing all default values not specified in the parameter file.
  B. The process checks the parameter syntax and then stops.

  ---

  In reference guide, page 131, and I quote "Without processing data, GoldenGate audits the syntax and connects to the database to verify that listed tables exist. If there is a syntax failure, the process abends with GoldenGate error 190. If the syntax succeeds, the process stops and writes a message to the report file that the parameters processed successfully."

• Question 10:

  You have a requirement to extract changes from an oracle 10g database without installing or running any GoldenGate processes on the host server. To accomplish this, which GoldenGate process parameter is most likely to be part of your solution?

  A. TRANLOGOPTIONS ARCHIVEDLOGONLY
  B. WILDCARDRESOLVE DYNAMIC
  C. This configuration is not supported in GoldenGate 10.
  D. ASSUMETARGETDEFS
  A. TRANLOGOPTIONS ARCHIVEDLOGONLY

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf