New Questions 4

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.

View Answer

New Questions 5

Which three are types of encryption supported by OGG?

A. Parameter file encryption

B. Password

C. Trial file encryption

D. Message encryption

View Answer

New Questions 6

You need to look up table definitions in a file. Which Replicat parameter should you use?

A. ASSUMETARGETDEFS

B. COLMATCH

C. SOURCEDEFS

D. MAP

View Answer

New Questions 7

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.

How should you accomplish this?

A. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.

B. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

C. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

D. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

View Answer

New Questions 8

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

View Answer

New Questions 9

Identify the correct statement regarding Trails.

A. Extract and Pump are different OS level executable binary files.

B. Extracts cannot perform filtering, mapping, and transformations.

C. RMTTRAILis for remote trails andEXTTRAILis for local trails.

D. Extract is typically used to produce local trail files over a TCP/IP connection.

View Answer

New Questions 10

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

A. @GETENV

B. GGHEADER

C. GGENVIRONMENT

D. u00a9TOKEN

View Answer

New Questions 11

Which option is supported by GoldenGate DDL replication?

A. CREATE ROLE

B. ALTER SYSTEM

C. ALTER DATABASE

D. ALTER TABLE SYS

View Answer

New Questions 12

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

View Answer

New Questions 13

Which Logdump command is used to check how many change records are in the trail file?

A. STATS

B. REPORT

C. REPORTCOUNT

D. COUNT

View Answer