Oracle GoldenGate 11g Certified Implementation Essentials

1.

Which utility is responsible for generating source data definitions files?

EMSCLNT COBGEN DDLGEN DEFGEN

2.

Which statement correctly describes GoldenGate Extract and Replicat process reports?

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. By default process reports are named for the Extract or Replicat group and up to 10 old reports are kept. 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 onthe REPORTNUM parameter. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved.

3.

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

4.

Which best describes the function of OGG user tokens?

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

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 11g Certified Implementation 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 11g Certified Implementation 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