1z1-481 Exam Training Practice Tests (Oracle GoldenGate 11g Certified Implementation Exam Essentials)]

Question 1

How do you control the size of the buffer that contains data extracted from?

A. DBOPTIONS BUFSIZE B. TRANLOGOPTIONS ASMBUFSIZE C. TRANLOGOPTIONS BUFSIZE D. DBOPTIONS ASMBUFSIZE

Correct Answer: C

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

Question 2

What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345?

A. Alter Replicat <group>, sequence lO, rba 100345 B. Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345 C. Alter <group>, sequence 10, rba 100345 D. Alter <group>, extseqno 10, extrba 100345

Correct Answer: D

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

Question 3

What is the GoldenGate command line interface?

A. GGCTRL B. SQLCUI C. GGSCI D. GGCUI

Correct Answer: C

Question 4

What GoldenGate facility allows for custom processing in response to a data value?

A. User Exits B. DDLGEN C. GGSExec D. User Tokens

Correct Answer: A

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

Question 5

What process is the recommended method to purge old GoldenGate trials?

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

Correct Answer: D

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

Question 6

Select the function that stores environmental values.

A. @GETENV B. GGENVIRONMENT C. @COLGEN D. ETOKEN

Correct Answer: A

Question 7

Which statement correctly describes GoldenGate Extract and Replicat process reports?

A. By default process reports are named for the Extract or Replicat group and up to 99 old reports can be saved depending on the REPORTUM parameter. B. Process reports take the name set by the optional report parameter of the ADD extract replicat command and up to 99 old reports can be saved depending on the REPORTNUM parameter. C. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved. D. By default process reports are named for the Extract or Replicat group and up to 10 old reports are kept.

Correct Answer: C

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

Question 8

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

A. Extract, Replicat and Manager B. Extract and Replicat C. Extract only D. Replicat only

Correct Answer: B

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

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