Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

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

Full Access
Question # 5

If multiple GoldenGate processes are accessing a set of trail files, which process should include the

PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

A.

Manager

B.

Replicat

C.

Extract

D.

Extract and Replicat

Full Access
Question # 6

For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

A.

Teradata

B.

Informix

C.

Sybase

D.

DB2

Full Access
Question # 7

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

A.

Extract r

B.

Replicat

C.

Manager

D.

Manager and Replica

Full Access
Question # 8

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

A.

ENCKEYS

B.

ENCRYPT

C.

GLOBALS

D.

CUSTKEYS

Full Access
Question # 9

You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

A.

File to Replicat

B.

GoldenGate Direct Load

C.

File to database utility

D.

Direct bulk load to SQL*Loader

Full Access
Question # 10

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you

differentiate the different Manager services?

A.

Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.

B.

Include the parameterSERVICENAMEin each Manager, with a unique name.

C.

Accept the default service name and manually edit within the Services applet.

D.

Multiple Manager services are not allowed on the same Windows server.

Full Access