1z1-481 by Oracle Actual Free Exam Questions And Answers

Question 1

Which could be used to map a value stored in a user token to a target column?

A. @TOKEN

B. GGHEADER

C. GGENVIRONMENT

D. @GETENV

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

What GoldenGate process is responsible for capturing changes in the source database?

A. Server Collector

B. Extract

C. Manager

D. Replicate

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

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. None: loop detection is on by default in Oracle.

B. Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.

C. Inserts will generate a primary key uniqueness violation; deletes will generate a 'no matching row' not found error; updates will continue forever.

D. New inserts will be processed without issue; updates and deletes will generate a "row not found" error.

Discussion 0

Correct Answer: A Vote an answer

Question 4

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?

A. DDL INCLUDE UNMAPPED in extra parameter file.

B. DDL INCLUDE MAPPED in extra parameter file.

C. This feature is not supported in oracle goldenGate 10.

D. DDL EXCLUDE MAPPED in extra parameter file.

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

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 a before image for updates and deletes

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

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

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

Discussion 0

Correct Answer: C Vote an answer

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

Question 6

How many Extracts can write to the same GoldGate trail?

A. Up to 10

B. Up to 50

C. Unlimited

D. Only one

Discussion 0

Correct Answer: D Vote an answer

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

Question 7

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. LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I

B. LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60

C. LAGREPOBT 1, I.AGCRITICALHOURS 1

D. LAGREPORTMINUTES 60, LAGINFOHOURS 1

Discussion 0

Correct Answer: D Vote an answer

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

Question 8

You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

C. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

D. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Discussion 0

Correct Answer: A Vote an answer

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

Oracle GoldenGate 11g Certified Implementation Exam Essentials - 1z1-481 Exam Practice Test

Contact Us

Useful Links

Latest Updated