Oracle 1z0-481 Oracle GoldenGate 11g Certified Implementation

Oracle 1z0-481

Oracle GoldenGate 11g Certified Implementation Exam

Essentials

Version: 2.0

QUESTION NO: 1

Which database platform does GoldenGate not natively support?

A. Sybase

B. FoxPro

C. DB2

D. Teradata

Answer: B

Explanation:

QUESTION NO: 2

What is the GoldenGate command line interface?

A. SQLCUI

B. GGSCI

C. GGCTRL

D. GGCUI

Answer: B

Explanation:

QUESTION NO: 3

When implementing GoldenGate on a 11gR2 Oracle database and after running the

GoldenGate Database profiling script, you discover that certain objects are compressed,

what should you do?

A. Contact Oracle support

B. Continue the implementation of OGG and exclude those objects from replication

C. Configure OGG with Classic Capture

D. Configure OGG with Integrated Capture

Answer: D

Explanation:

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 2

QUESTION NO: 4

Which Replicat parameter is used when looking up table definitions in a file?

A. SPECIALRUN

B. DEFERAPPLYINTERVAL

C. SOURCEISFILE

D. SOURCEDEFS

Answer: D

Explanation:

QUESTION NO: 5

Select the function that stores environmental values.

A. GGENVIRONMENT

B. @COLGEN

C. @GETENV

D. ETOKEN

Answer: C

Explanation:

QUESTION NO: 6

Select the statement that is supported by OGG DDL Replication.

A. ENCRYPT

B. ALTGLOBAL

C. CREATE ROLE

D. ALTDB

Answer: C

Explanation:

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 3

QUESTION NO: 7

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

Explanation:

QUESTION NO: 8

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. LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60

B. LAGREPORTMINUTES 60, LAGINFOHOURS 1

C. LAGREPOBT 1, I.AGCRITICALHOURS 1

D. LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I

Answer: B

Explanation: Reference :

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

QUESTION NO: 9

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 4

What parameter provides options for compression and encryption?

A. RMTHOST

B. TARGET

C. TCPIP

D. TARGET DB

Answer: A

Explanation:

Reference :

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

QUESTION NO: 10

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

A. Manager

B. Replicate

C. Extract

D. Server Collector

Answer: C

Explanation:

Reference:

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

QUESTION NO: 11

You have configured and added the extract and Replicate tasks using the direct load method what

do you need to do to get the processes up and running?

A. Start the Extract task.

B. Start the Extract task and then start the Replicat task.

C. Start the Extract task; wait for it to stop and than start the Replicate task.

D. Start the Replicate task

Answer: A

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 5

Explanation:

In reference guide, page 279, "Use the RMTTASK parameter for an initial-load Extract to initiate a

Replicat processing task during a GoldenGate direct load or a direct bulk load to SQL*Loader.

RMTTASK directs Extract to communicate directly with Replicat over TCP/IP and bypasses the

use of aCollector process or disk storage. RMTTASK also directs Extract to request that

Managerstart Replicat automatically, and then stop Replicat when the run is finished. "

QUESTION NO: 12

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

QUESTION NO: 13

What us expected behavior of CHEKPARMS parameter?

A. The process checks the parameter syntax and then starts running.

B. The process checks the parameter syntax and then stops.

C. A report file is created listing all missing parameters.

D. A report file is created listing all default values not specified in the parameter file.

Answer: B

Explanation:

In reference guide, page 131, and I quote "Without processing data, GoldenGate audits the syntax

and connects to the database to verify that listed tables exist. If there is a syntax failure, the

process abends with GoldenGate error 190. If the syntax succeeds, the process stops and writes

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 6

a message to the report file that the parameters processed successfully."

QUESTION NO: 14

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

QUESTION NO: 15

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

A. TRANLOGOPTIONS ASMBUFSIZ

B. DBOPTIONS ASMBUFSIZE

C. TRANLOGOPTIONS BUFSIZE

D. DBOPTIONS BUFSIZE

Answer: A

Explanation:

Reference :

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

QUESTION NO: 16

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

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 7

A. TRANLOGOPTIONS ASMBUFSIZE

B. DBOPTIONS ASMBUFSIZE

C. TRANLOGOPTIONS BUFSIZE

D. DBOPTIONS BUFSIZE

Answer: C

Explanation:

Reference :

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

QUESTION NO: 17

What three are valid responsibilities of the OGG Manager?

A. Cleaning up GoldenGate trails.

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

C. Error and lag reporting.

D. Communicating with other GoldenGate Manager processes

Answer: A,B,C

Explanation:

Reference:

http://gavinsoorma.com/2010/02/goldengate-tutorial-3-configuring-the-manager-process/

http://space.itpub.net/10248702/viewspace-624577

QUESTION NO: 18

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. Inserts will generate a primary key uniqueness violation; deletes will generate a ‘no

matching row’ not found error; updates will continue forever.

B. None: loop detection is on by default in Oracle.

C. New inserts will be processed without issue; updates and deletes will generate a “row

not found” error.

D. Updates and deletes will be replicated without issue new inserts will generate a primary

key uniqueness violation.

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 8

Answer: B

Explanation:

QUESTION NO: 19

What three types of information are reported in discard file?

A. The details of the discarded records

B. The database error message

C. The trial file sequence number

D. Runtime statistics

Answer: A,B,C

Reference:

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

QUESTION NO: 20

Which command forces a running Extract to close the current trial and start writing to the

next trial sequence number?

A. ALTER EXTTRAIL <trail name>, NEXTSEQNO

B. ALTER EXTTRAIL <trail name>, ROLLOVER

C. SEND EXTRACT <group>, ETROLLOVER

D. SEND EXTRACT <group>, ROLLOVER

Answer: D

Explanation:

In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR

{CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID>

[THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER

|SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>]

[TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS |STOP

|TLTRACE {DEBUG | OFF | <level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2]

<tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS

{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS}

|TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |VAMMESSAGE “<Teradata

command>” |VAMMESSAGE {“ARSTATS” | “INCLUDELIST [filter]” | “EXCLUDELIST [filter]”}

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 9

|VAMMESSAGE “OPENTRANS”}

QUESTION NO: 21

To meet a business requirement for latency, Carlos wants to break long-running source

transactions into shorter commits on the target database with the replicate parameter

MAXTRANSOPS what is the most important thing Carlos should consider before using

MAXTRANSOPS

A. Will business logic be lost if transaction boundaries are changed?

B. Will a large number of small commits perform better than a smaller number of large

commits?

C. Will redo buffer size on the target database be adequate for the commit size?

D. Will the sequence of operations be affected by changing transaction boundaries?

Answer: D

Explanation:

In reference guide, page 238: "Limitations of useYou should have a valid business case for using

MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to

alter the transactional integrity that isimposed by the boundaries that are defined by the source

application, even though Replicatapplies the operations in the correct order."

QUESTION NO: 22

In GoldenGate terms, what is the definition of Extract lag?

A. The difference in time between when a change is made to source data and when that change is

reflected in the target data.

B. The difference in time between the current times at the target system.

C. The difference in time between when a change record is received at the target system and

when the change is reflected in the target data.

D. The difference in time between when a change record is processed by the extract and the

timestamp of the record in the data source.

Answer: D

Explanation: Reference :

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

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 10

QUESTION NO: 23

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

QUESTION NO: 24

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. From the Data Pump process

C. From replicate process

D. This feature is not supported in GoldenGate 10.

Answer: A

Reference:

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

QUESTION NO: 25

You are responsible for replication between your central office and twelve regional nodes.

What is the best product for you to use to actively monitor thirteen GoldenGate TDM

instances and configure email alerts based on process status?

A. Oracle GoldenGate Director

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 11

B. Oracle GoldenGate Transactional Data Management

C. Oracle GoldenGate veridata

D. Oracle GoldenGate Monitor

Answer: A

Explanation:

Oracle GoldenGate Director is the only tool for the job.

Incorrect answer:

There isn't a GoldenGate Monitor application

QUESTION NO: 26

Which GGSCI command(s) show all available information on both read and write

checkpoint for an Extract?

Example: 1 INFO EXTRACT <group name>

Example: 2 INFO EXTRACT <group name>, DETAIL

Example: 3 INFO EXTRACT <group name>, SHOWCH

A. Example 2 only

B. Example 3 only

C. Examples 1 and 3

D. Examples 1 and 2

Answer: B

Explanation: Reference :

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

QUESTION NO: 27

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

A. EXTTRAILSOURCE

B. SOURCEISTABLE

C. SOURCEISTRAIL

D. LOCTRAILSOURC

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 12

Answer: A

Explanation: On page 293 of reference guide, EXTTRAILSOURCE is the parameter to specify

data pump

QUESTION NO: 28

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

Answer: A

Explanation:

QUESTION NO: 29

Where can you find a list of the parameters being used by a Replicat process?

A. System logs

B. Discard file

C. Event log

D. Process report

Answer: D

Explanation: http://gjilevski.wordpress.com/2010/02/27/monitoring-processes-and-processingstatus-

in-oracle-goldengate/

QUESTION NO: 30

Which process (es) maintain a checkpoint file?

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 13

A. Extract only

B. Replicat only

C. Both Extract and Replicat

D. Server collector

Answer: C

Reference:

http://dbmentors.blogspot.com/2010/12/oracle-goldengate-tutorial-part-1.html

QUESTION NO: 31

In addition to using the parameter comment to enter remarks in parameter file(s) can be used?

A. - -

B. //

C. \\

D. /*

Answer: A

Explanation:

QUESTION NO: 32

Which three can GoldenGate encrypt?

A. Extract to Server messages

B. Trails

C. Passwords

D. Redo logs

Answer: A,B,C

Explanation:

Reference:

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

QUESTION NO: 33

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 14

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

A. Table

B. LOGTABLE

C. MAP C

D. LOG

Answer: A

Reference:

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

QUESTION NO: 34

Where are GoldenGate macros defined?

A. Macros can be defined in the parameter file or included in a macro file

B. Macros are defined in the GLOBALS parameter file

C. Macros are placed in a file and referenced using an environment variable.

D. Macros are declared, compiled and referenced via Golden Gate’s user exits.

Answer: A

Reference:

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

QUESTION NO: 35

If your system has a firewall controlling port access which parameter can be used to control ports

used for GoldenGate processes?

A. CHILDPORTS

B. ALLOWEDPORTS

C. DYNAMICPORTLIST

D. GETPORTINFO

Answer: C

Explanation:

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 15

QUESTION NO: 36

Which statement best describes the record Image that an Extract process stores in the

GoldenGate trail by default?

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

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

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

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

Answer: D

Explanation: An after image for inserts and updates and a before image for deletes.According to

these guides:1. http://docs.oracle.com/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf, page

190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the

parameters which control whether or not the after/before images of updated records are included

in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version

10.4, page 113, Extract Parameters, Extract Parameter Defaults slide… Only after-image of

update

QUESTION NO: 37

When GoldenGate is configured for Archived Only Mode (ALO), what must be considered

configuring the middle-tier server for Capture?

A. The middle-tier capture server has the same endian order and bit width

B. The middle-tier server must have a database installed on it

C. GoldenGate only supports Windows or Linux on the middle-tier server

D. GoldenGate only supports UNIX on the middle-tier server

Answer: B

Explanation:

QUESTION NO: 38

You are configuring a multi-master DDL replication environment. To prevent looping of DDL

statement like CREATE TABLE (….), the best solution is______.

A. Include the tranlogoptions (exclude user) parameter in each Extract parameter file

B. Use the add FILTERTABLE command at the GGSCI prompt

C. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 16

D. This feature is not supported in GoldenGate 10.

Answer: C

Reference:

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

QUESTION NO: 39

You have source table with PRODUCT-ID column and target table with

PRODUCT_DESCRIPTION. On the target database is a lookup table containing product

codes and corresponding description. What is good way for you to lookup the product

description for each transaction?

A. SQLEXEC ( )

B. DBLOOKUP ( )

C. DBLOGIN ()

D. SQLLOOKUP ( )

Answer: A

Explanation: In reference guide, page 236, in example 1 or Example 2, when a lookup is

available, SQLEXEC() is the function to use.

Incorrect answer:

There isn't a SQLLOOKUP() function in GoldenGate!

QUESTION NO: 40

How many Extracts can write to the same GoldGate trail?

A. Only one

B. Up to 10

C. Up to 50

D. Unlimited

Answer: A

Explanation: http://jianmingli.com/wp/?p=1534

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 17

-

QUESTION NO: 41

Which utility is responsible for generating source data definitions files?

A. EMSCLNT

B. COBGEN

C. DDLGEN

D. DEFGEN

Answer: D

Reference:

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

QUESTION NO: 42

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. By default process reports are named for the Extract or Replicat group and up to 10 old

reports are kept.

C. 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.

D. Process reports take the name set by the required report file parameters and up to 10 old

reports will be saved.

Answer: D

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

QUESTION NO: 43

Which statements are true for a two-node, active-active OGG replication configuration?

Both databases may be live and processing transactions.

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 18

-

-

The two databases must be homogeneous.

Low latency reduces the risk of conflicts.

A. 1 and 2

B. 2 and 3

C. 1 and 3

D. I, 2, and 3

Answer: C

Reference:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2812197300346109

609

QUESTION NO: 44

What is GGSCI an acronym for?

A. GoldenGate secure command interface

B. GoldenGate software command interface

C. GoldenGate software connection interface

D. GoldenGate secure connection interface

Answer: B

Reference:

http://gavinsoorma.com/tag/ggsci/

QUESTION NO: 45

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

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 19

Answer: A

Reference:

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

QUESTION NO: 46

Where is user token data stored?

A. Trail file

B. Parameter file

C. Discord file

D. Report file

Answer: A

Reference:

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

QUESTION NO: 47

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

address 100345?

A. Alter <group>, extseqno 10, extrba 100345

B. Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345

C. Alter Replicat <group>, sequence lO, rba 100345

D. Alter <group>, sequence 10, rba 100345

Answer: A

Explanation:

Reference:

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

QUESTION NO: 48

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 20

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 first unique key alpha-numerically, excluding virtual columns and nullable columns,

will be treated as the primary key.

B. This configuration is not supported by GoldenGate; Replicat will abend on updates or

deletes.

C. The first column, excluding virtual columns and nullable columns, will be treated as the

pr key.

D. The combination of all fields up to the first thirty-two will be treated as a compound

primary key

Answer: A

Reference:

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

QUESTION NO: 49

Which best describes the function of OGG user tokens?

A. User-defined variables

B. Security tokens

C. User privileges

D. User-defined functions

Answer: A

Explanation:

QUESTION NO: 50

What could you use to formal 123456789 to format of social security number 123-456-789?

A. @STRCAT ()

B. @STEXT ()

C. @strext () and @ strcat ()

D. @STRFIND ( )

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 21

Answer: C

Reference:

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

QUESTION NO: 51

Replicat is responsible for which three options?

A. Reading data out of the GoldenGate trails.

B. Performing data flow filtering.

C. Performing data transformations.

D. Check pointing the oldest uncommitted transaction.

Answer: A,B,C

Explanation:

QUESTION NO: 52

What GoldenGate process writes to RMTTRAILS?

A. Server/Collector

B. Extract

C. Pump

D. Replicat

E. All of the above

Answer: B

Reference:

http://hi.baidu.com/nich4/blog/item/19a3e81cad1ff7bb4bedbc50.html

QUESTION NO: 53

How does Replicat know the structure of the source tables when the target has a different layout?

A. GoldenGate trail file contains the metadata of incoming data

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 22

B. Replicat uses an ODBC connection to connect to the source system tables

C. Parameter file contains table layouts

D. Discard file contains table layouts

E. Source Definitions file contains table layouts

Answer: E

Reference:

http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-8-filtering-and-mapping-data/

QUESTION NO: 54

What is the default threshold for message compression in OGG?

A. 1000

B. 100

C. O

D. By default, messages are not compressed.

Answer: A

Reference:

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

QUESTION NO: 55

What is the name and the location of the file that lists the key values used by extract for

encryptions and Server Collector for decryption?

A. KEYGEN file in the GoldenGate data location

B. COBGEN file in the GoldenGate installation location

C. GGSKEY file in the GoldenGate data location

D. GGSKEY file in the GoldenGate installation location

E. ENCKEYS file in the GoldenGate installation location

Answer: E

Reference:

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 23

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

QUESTION NO: 56

By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

Answer: E

Reference:

http://www.labo-oracle.com/Presentation-of-Oracle-GoldenGate

QUESTION NO: 57

Which three are types of encryption supported by OGG?

A. Parameter file encryption

B. Password

C. Trial file encryption

D. Message encryption

Answer: A,B,C

Explanation:

QUESTION NO: 58

Which three are required to correctly configure an OGG?

A. A maximum file size

B. An extract process

C. A trail file identifier

D. Designation as local or remote

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 24

Answer: B,C,D

Reference:

http://www.biblogs.com/2010/03/22/configuring-odi-10136-to-use-oracle-golden-gate-for-changeddata-

capture/

http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/

QUESTION NO: 59

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

A. Extract r

B. Replicat

C. Manager

D. Manager and Replica

Answer: C

Reference:

http://forums.oracle.com/forums/thread.jspa?messageID=9297810

QUESTION NO: 60

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A. The target tables are already created.

B. Only the fields in the target tables are mapped.

C. The source and target tables have identical data structure.

D. You have specified wildcards in either the TABLE or MAP parameters

Answer: C

Reference:

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

QUESTION NO: 61

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 25

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."

QUESTION NO: 62

Which parameter could you use to start an Extract when Manager starts?

A. START

B. BEGIN

C. AUTOSTART

D. PROCESS

Answer: C

Reference:

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

QUESTION NO: 63

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

A. @GETENV

B. GGHEADER

C. GGENVIRONMENT

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 26

D. ©TOKEN

Answer: D

Reference:

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

QUESTION NO: 64

Ideally which process should be configured purge old trial files?

A. Manager

B. Extract

C. Replicat

D. Pump

Answer: A

Reference:

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

QUESTION NO: 65

When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database

connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be

read by a local Replicat.

Answer: A

Reference:

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

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 27

QUESTION NO: 66

Which three types of information are stored in the GoldenGate trial header?

A. Before or after image indicator

B. Data type (e.g. integer, alphanumeric)

C. Relative byte address of the commit record

D. Time of the transaction

Answer: A,B,C

Reference:

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

QUESTION NO: 67

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Checkpointing

B. Sub-second latency

C. Two-phase commits

D. Transactional integrity

Answer: A

Explanation:

QUESTION NO: 68

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS

FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB

data?

A. The Extract will revert to single-row fetch mode, and then resume array fetches

afterwards.

B. The Extract will revert to single-row fetch mode for all tables.

C. The Extract will abend unless LOBMEMORY is increased.

D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Answer: A

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 28

Explanation:

QUESTION NO: 69

What file must be configured in order to use custom encryption keys?

A. ENCKEYS

B. ENCRYPT

C. GLOBALS

D. CUSTKEYS

Answer: A

Reference:

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

QUESTION NO: 70

Which parameters) would be used for one-time initial replicat?

A. PASSTHRU

B. SOURCEISFILE

C. CHECKMINUTES

D. SOURCEISTABLE

E. SPECIALRUN

Answer: E

Reference:

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

QUESTION NO: 71

What is the default format for a GoldenGate trail?

A. ASCII:ASCII format

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 29

B. INPUT ASCII: from 1to 127 representing ASCII characters

C. SQL: SQL statements

D. CDF: Canonical Data format

E. XML: XML statement

Answer: A

Explanation:

QUESTION NO: 72

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. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn

to HANDLECOLLISIONS in the Replicat.

C. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and

regenerate the checkpoint table.

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

Answer: A

Reference:

http://www.outofboundstechnology.com/files/oracle/oraclegg_part3_trouble.pdf

QUESTION NO: 73

Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START

EXTRACT at 2:00 p.m.?

A. Transactions started on or after 1:00 p.m.

B. Transactions started on or after 2:00 p.m.

C. Transactions started before 1:00 p.m and committed after 1:00 p.m.

D. Transactions started before 1:00 p.m and committed after 2:00 p.m.

Answer: D

Explanation:

The START EXTRACT starts the Extract and Data Pump processes.

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 30

Reference:

http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/

QUESTION NO: 74

You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate

manage process is running on port 7809. Your requirements include using a custom encryption

key and advanced encryption standard (AES), and you have created an ENCKEYS file

What parameters should you use?

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

B. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY

C. RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809

D. RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY

Answer: D

Explanation: Reference :

http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/

QUESTION NO: 75

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: A,B,C

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]][, ...])

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 31

QUESTION NO: 76

By default, which option is evaluated first, SQLEXEC or filter statement?

A. SQLEXEC

B. FILTER

C. There is no default; it is set with the after filter I before filter.

D. It depends on their position in the parameter file; the first encountered is executed first.

Answer: B

Explanation:

QUESTION NO: 77

Which argument is used to set the maximum size of the EXTTRAIL or RMTTRAL.

A. MAXSIZE

B. TRAILSIZE

C. HAXTRAILSI2E

D. TRAILMAXSIZE F

E. MEGABYTES

Answer: E

Explanation: In reference guide, page 69, MEGABYTES is the parameter to set maximum size of

trail files.

QUESTION NO: 78

Which statements are true of goldenGate password encryption?

A password can be encrypted and pasted into a parameter file.

An encrypted password can be generated using the default key.

An encrypted password can be generated using a user defined-key.

A. 1 only

B. 2 only

C. 3 only

D. 1 and 3

E. 1, 2 and 3

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 32

Answer: E

Explanation:

One of the encryption options that GoldenGate provides is to use Passwords in the extract

and replicate parameter file. Also, the encrypted password can be generated using user

defined key up to 128-bit or using the default key.

Reference:

http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/

QUESTION NO: 79

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. This feature is not supported in oracle goldenGate 10.

B. DDL INCLUDE MAPPED in extra parameter file.

C. DDL INCLUDE UNMAPPED in extra parameter file.

D. DDL EXCLUDE MAPPED in extra parameter file.

Answer: B

Explanation:

DDL INCLUDE MAPPED in extra parameter file. This means that DDL support is now enabled for

all tables which have been mapped

Reference :

http://gjilevski.wordpress.com/2010/02/19/configuring-ddl-synchronization-with-oracle-goldengate/

Oracle 1z0-481 Exam

"Pass Any Exam. Any Time." - www.actualtests.com 33