Want to know Pass4sure 1z0-481 Exam practice test features? Want to lear more about Oracle Oracle GoldenGate 11g Certified Implementation Exam Essentials certification experience? Study Download Oracle 1z0-481 answers to Up to date 1z0-481 questions at Pass4sure. Gat a success with an absolute guarantee to pass Oracle 1z0-481 (Oracle GoldenGate 11g Certified Implementation Exam Essentials) test on your first attempt.


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1z0-481 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1z0-481 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1z0-481-exam-dumps.html

Q41. 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

Answer: A

Explanation:

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. "


Q42. Which OGG process (es) can change data in database?

A. Replicat only

B. Extract only

C. Extract and Replicat

D. Extract, Replicat and Manager

Answer: C

Explanation: 

Reference :

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


Q43. Select the commands that give statistics regarding OGG process and memory resource usage.

A. SEND…REPORT

B. SEND…STATS

C. SEND...CACHEMGR

D. INFO…SHOWSTATS

Answer: C


Q44. You have a source installation of OGG l0 that includes an initial extract and datapump to provide a remote trail formatted for a GoldenGate 9.5 Replicat process to consume, which process should be use to convert the data to the earlier format?

A. From the first Extract process

B. From the Data Pump process

C. From replicate process

D. This feature is not supported in GoldenGate 10.

Answer: A

Explanation:

Reference:

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


Q45. You want to configure replication of CREATE TABLE statements from oracle to Teradata, so that only new table created in your mapped source schema is Replicated. Which should be the part of solution?

C. DDL INCLUDE UNMAPPED in extra parameter file.

D. DDL EXCLUDE MAPPED in extra parameter file.

Answer: B

Explanation:

DDL INCLUDE MAPPED in extra parameter file. This means that DDL support is now enabled for all tables which have been mapped

Reference :

http://gjilevski.wordpress.com/2010/02/19/configuring-ddl-synchronization-with-oracle- goldengate/


Q46. Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

A. The new value for updated fields; the primary key for deleted rows; the after-Image for inserts

B. An image of the contents of the record after the insert, update or delete operation

C. An after image for inserts and a before image for updates and deletes

D. An after image for Inserts and updates and a before image for deletes

Answer: D

Explanation: An after image for inserts and updates and a before image for deletes.According to these guides:1. 

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

page 190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the parameters which control whether or not the after/before images of updated records are included in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version 10.4, page 113, Extract Parameters, Extract Parameter Defaults slide… Only after-image of update


Q47. 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

Answer: D

Explanation: 

Reference :

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