Oracle GoldenGate 19c Implementation Professional Sample Questions:

1. What is the purpose of a data pump Extract in Oracle GoldenGate?

A) Directly applies changes to target
B) Encrypts trail files
C) Reads from local trail and forwards to remote system
D) Monitors performance metrics

2. Replicat Abends with the message "Missing KEYNAME specification". Which parameter is the cause for this condition?

A) DECRYPTTRAIL
B) DECRYPTTRAIL AES128, KEYNAME
C) According to Oracle's documentation, DECRYPTTRAIL requires both an encryption algorithm (e.g., AES128) and a KEYNAME clause. If KEYNAME is omitted (as in Option B), Replicat throws the "Missing KEYNAME specification" error.
D) DECRYPTTRAIL AES128, KEYNAME RepKey

3. Which is an incorrect option to use with the DBOPTIONS parameter for a Replicat?

A) USEODBC
B) USEREPLICATIONUSER
C) NOCATALOGCONNECT
D) BATCHSQL

4. Integrated delivery works only with trail files from integrated capture.

A) FALSE
B) TRUE

5. What is the purpose of the GoldenGate Initial Load?

A) To carry out Performance Load Testing
B) To stream change data to a target database
C) To create the target database objects
D) To synchronize data in the source and target databases

Solutions: