Oracle GoldenGate 11g Certified Implementation Exam Essentials (1z0-481) Free Practice Test

Question 1

Ideally which process should be configured purge old trial files?

A. Extract

B. Manager

C. Pump

D. Replicat

Correct Answer: B

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

Question 2

Select the function that stores environmental values.

A. @COLGEN

B. @GETENV

C. GGENVIRONMENT

D. ETOKEN

Correct Answer: B

Question 3

What three are valid responsibilities of the OGG Manager?

A. Error and lag reporting.

B. Starting dynamic processes, such as Server Collectors, extracts, replicates.

C. Cleaning up GoldenGate trails.

D. Communicating with other GoldenGate Manager processes

Correct Answer: A,B,C

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

Question 4

Which utility is responsible for generating source data definitions files?

A. DEFGEN

B. EMSCLNT

C. DDLGEN

D. COBGEN

Correct Answer: A

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

Question 5

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

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

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

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

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

Correct Answer: C

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

Question 6

How would you specify the data source for a secondary Extract functioning as a data pump?

A. SOURCEISTABLE

B. SOURCEISTRAIL

C. EXTTRAILSOURCE

D. LOCTRAILSOURC

Correct Answer: C

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

Question 7

In order to add delete Replicat processes without specifying a checkpoint table, Gerald has edited the GLOBALS parameter file. To get the change to take effect, Gerald exits from the GGSCI command line, but GGSCI fails to restart. Which solution Is most likely to solve Gerald's problem

A. Verify that Oracle environment variables are set correctly

B. Use the cleanup replicat command

C. Use a text editor to check the GLOBALS file for syntax errors and fix them

D. Add the Oracle GoldenGate Installation directory to the system PATH

Correct Answer: C

Question 8

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Two-phase commits

B. Transactional integrity

C. Sub-second latency

D. Checkpointing

Correct Answer: D

Welcome to TestSimulate

Oracle GoldenGate 11g Certified Implementation Exam Essentials (1z0-481) Free Practice Test