You will get the particular in depth description once you encounter difficulties during your 1z0-481 research. Pass4sure supply you the particular 1z0-481 Oracle GoldenGate 11g Certified Implementation Exam Essentials tips legibly inside the 1z0-481 puts. All these are greatly conserving your own expenditures to get familiar with the particular Oracle classes.

2016 Jun 1z0-481 test question

Q31. If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

A. Manager

B. Extract

C. Replicat

D. Both Extract and Replicat

Answer: A

Explanation:

In reference guide, page 256, and I quote "If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all GoldenGate configurations because it allows you to manage trail files in a centralized fashion."


Q32. Select the function that stores environmental values.

A. GGENVIRONMENT

B. @COLGEN

C. @GETENV

D. ETOKEN

Answer: C


Q33. You have a requirement to extract changes from an oracle 10g database without installing or running any GoldenGate processes on the host server. To accomplish this, which GoldenGate process parameter is most likely to be part of your solution?

A. TRANLOGOPTIONS ARCHIVEDLOGONLY

B. WILDCARDRESOLVE DYNAMIC

C. This configuration is not supported in GoldenGate 10.

D. ASSUMETARGETDEFS

Answer: A

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf


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

A. Replicat only

B. Extract only

C. Extract and Replicat

D. Extract, Replicat and Manager

Answer: C

Explanation: 

Reference :

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf


Q35. Which parameter tells Extract the tables for which to capture changes?

A. Table

B. LOGTABLE

C. MAP C

D. LOG

Answer: A

Explanation:

Reference:

http://jianmingli.com/wp/?p=1532


certifyforall.com

Renew 1z0-481 practice:

Q36. You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?

A. No

B. Yes, if the source and target Oracle versions and character sets are the same.

C. Yes

D. Yes, as long as the source table has a primary key define

Answer: A

Explanation:

In reference guide, page 119, when replicating from identical sources to targets, the param ASSUMETARGETDEFS must be used, and the only with being with columns in different orders, the answer is NO


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

A. DDLGEN

B. GGSExec

C. User Exits

D. User Tokens

Answer: C 

Explanation: 

Reference :

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf


Q38. Ideally which process should be configured purge old trial files?

A. Manager

B. Extract

C. Replicat

D. Pump

Answer: A

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf


Q39. Select the commands that give statistics regarding OGG process and memory resource usage.

A. SEND…REPORT

B. SEND…STATS

C. SEND...CACHEMGR

D. INFO…SHOWSTATS

Answer: C


Q40. Which three describe a valid OGG Event Action?

A. Stop the process

B. Write a checkpoint before and/or after writing the record to the trail.

C. Run a shell command

D. Purge old trail files

Answer: ABC

Explanation:

In reference guide, page 312, Syntax EVENTACTIONS ([STOP | ABORT | FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG [INFO | WARNING]][REPORT][ROLLOVER][SHELL <command>][TRACE <trace file> [TRANSACTION] [PURGE | APPEND]][CHECKPOINT [BEFORE | AFTER | BOTH]][, ...])