Oracle GoldenGate 10 Essentials

1.

Where is user token data stored?

Trail file Parameter file Discord file Report file

2.

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

Alter < group>, extseqno 10, extrba 100345

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

Alter Replicat < group>, sequence lO, rba 100345

Alter < group>, sequence 10, rba 100345

3.

Which best describes the function of OGG user tokens?

User-defined variables Security tokens User privileges User-defined functions

4.

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?

The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes. The first column, excluding virtual columns and nullable columns, will be treated as the pr key. The combination of all fields up to the first thirty-two will be treated as a compound primary key

5.

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

@STRCAT () @STEXT () @strext () and @strcat () @STRFIND ( )

6.

Replicat is responsible for which three options?

Reading data out of the GoldenGate trails. .Performing data flow filtering. Performing data transformations. Check pointing the oldest uncommitted transaction.

7.

What GoldenGate process writes to RMTTRAILS?

Server/Collector Extract Pump Replicat All of the above

8.

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

GoldenGate trail file contains the metadata of incoming data Replicat uses an ODBC connection to connect to the source system tables Parameter file contains table layouts Discard file contains table layouts Source Definitions file contains table layouts

9.

What is the default threshold for message compression in OGG?

1000 100 O By default, messages are not compressed.

10.

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?

KEYGEN file in the GoldenGate data location COBGEN file in the GoldenGate installation location GGSKEY file in the GoldenGate data location GGSKEY file in the GoldenGate installation location ENCKEYS file in the GoldenGate installation location

Oracle GoldenGate 10 Essentials

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle GoldenGate 10 Essentials

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner