Oracle GoldenGate 11g Certified Implementation Exam Essentials - 1z1-481 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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. RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY B. This feature is not supported in oracle goldenGate 10. C. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY D. RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

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 Data Pump process B. From replicate process C. This feature is not supported in GoldenGate 10. D. From the first Extract process

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?

A. LAGREPOBT 1, I.AGCRITICALHOURS 1 B. LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I C. LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60 D. LAGREPORTMINUTES 60, LAGINFOHOURS 1

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

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

A. An after image for Inserts and updates and a before image for deletes 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. The new value for updated fields; the primary key for deleted rows; the after-Image for inserts

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Where can you find a list of the parameters being used by a Replicat process?

A. Process report B. Discard file C. Event log D. System logs

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

Which parameter could you use to start an Extract when Manager starts?

A. BEGIN B. PROCESS C. AUTOSTART D. START

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

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.

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which statements are true of goldenGate password encryption?
A password can be encrypted and pasted into a parameter file.
An encrypted password can be generated using the default key.
An encrypted password can be generated using a user defined-key.

A. 1 and 3 B. 1, 2 and 3 C. 2 only D. 3 only E. 1 only

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).