Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 71:

  You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption key and advanced encryption standard (AES), and you have created an ENCKEYS file

  What parameters should you use?

  A. This feature is not supported in oracle goldenGate 10.
  B. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY
  C. RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809
  D. RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY
  D. RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY

  ---

  Reference : http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/

• Question 72:

  What three are valid responsibilities of the OGG Manager?

  A. Cleaning up GoldenGate trails.
  B. Starting dynamic processes, such as Server Collectors, extracts, replicates.
  C. Error and lag reporting.
  D. Communicating with other GoldenGate Manager processes
  A. Cleaning up GoldenGate trails.
  B. Starting dynamic processes, such as Server Collectors, extracts, replicates.
  C. Error and lag reporting.

  ---

  Reference: http://gavinsoorma.com/2010/02/goldengate-tutorial-3-configuring-the-manager-process/ http://space.itpub.net/10248702/viewspace-624577

• Question 73:

  You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

  A. Inserts will generate a primary key uniqueness violation; deletes will generate a `no matching row' not found error; updates will continue forever.
  B. None: loop detection is on by default in Oracle.
  C. New inserts will be processed without issue; updates and deletes will generate a "row not found" error.
  D. Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.
  B. None: loop detection is on by default in Oracle.

• Question 74:

  What process is the recommended method to purge old GoldenGate trials?

  A. Extract r
  B. Replicat
  C. Manager
  D. Manager and Replica
  C. Manager

  ---

  Reference: http://forums.oracle.com/forums/thread.jspa?messageID=9297810

• Question 75:

  Which three are required to correctly configure an OGG?

  A. A maximum file size
  B. An extract process
  C. A trail file identifier
  D. Designation as local or remote
  B. An extract process
  C. A trail file identifier
  D. Designation as local or remote

  ---

  Reference:

  http://www.biblogs.com/2010/03/22/configuring-odi-10136-to-use-oracle-golden-gate-for-changed- data-capture/

  http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/

• Question 76:

  What parameter provides options for compression and encryption?

  A. RMTHOST
  B. TARGET
  C. TCPIP
  D. TARGET DB
  A. RMTHOST

  ---

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

• Question 77:

  What is the default threshold for message compression in OGG?

  A. 1000
  B. 100
  C. O
  D. By default, messages are not compressed.
  A. 1000

  ---

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

• Question 78:

  By default, which option is evaluated first, SQLEXEC or filter statement?

  A. SQLEXEC
  B. FILTER
  C. There is no default; it is set with the after filter I before filter.
  D. It depends on their position in the parameter file; the first encountered is executed first.
  B. FILTER

• Question 79:

  You have configured and added the extract and Replicate tasks 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 and then start the Replicat task.
  C. Start the Extract task; wait for it to stop and than start the Replicate task.
  D. Start the Replicate task
  A. Start the Extract task.

  ---

  In reference guide, page 279, "Use the RMTTASK parameter for an initial-load Extract to initiate a Replicat processing task during a GoldenGate direct load or a direct bulk load to SQL*Loader. RMTTASK directs Extract to communicate directly with Replicat over TCP/IP and bypasses the use of aCollector process or disk storage. RMTTASK also directs Extract to request that Managerstart Replicat automatically, and then stop Replicat when the run is finished. "