Oracle GoldenGate 11g Certified Implementation Exam Essentials

QUESTION NO: 1
Which parameter tells Extract the tables for which to capture changes?

A. LOGTABLE B. LOG C. Table D. MAP C

Correct Answer: C

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

QUESTION NO: 2
Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

A. SEND EXTRACT <group>, ETROLLOVER B. ALTER EXTTRAIL <trail name>, ROLLOVER C. ALTER EXTTRAIL <trail name>, NEXTSEQNO D. SEND EXTRACT <group>, ROLLOVER

Correct Answer: D

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

QUESTION NO: 3
How many Extracts can write to the same GoldGate trail?

A. Only one B. Up to 10 C. Up to 50 D. Unlimited

Correct Answer: A

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

QUESTION NO: 4
Select the commands that give statistics regarding OGG process and memory resource usage.

A. INFO...SHOWSTATS B. SEND...STATS C. SEND...REPORT D. SEND...CACHEMGR

Correct Answer: D

QUESTION NO: 5
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. Use a text editor to check the GLOBALS file for syntax errors and fix them B. Use the cleanup replicat command C. Verify that Oracle environment variables are set correctly D. Add the Oracle GoldenGate Installation directory to the system PATH

Correct Answer: A

QUESTION NO: 6
What process is the recommended method to purge old GoldenGate trials?

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

Correct Answer: A

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

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

Correct Answer: A

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

QUESTION NO: 8
Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?

A. The combination of all fields up to the first thirty-two will be treated as a compound primary key B. The first column, excluding virtual columns and nullable columns, will be treated as the pr key. C. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key. D. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.

Correct Answer: C

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

Oracle GoldenGate 11g Certified Implementation Exam Essentials - 1z0-481 Exam Questions