Ultimate Guide to Prepare 1Z1-947 Certification Exam for Oracle GoldenGate in 2026 [Q21-Q35]

Q21. Replicat makes checkpoints in the trail file to mark its last read position. How can you create a checkpoint table?

Use the ADD CHECKPOINTTABLE command.

Use the INFO REPLICAT command with the SHOWCH option.

Use the ADD Extract Trail command.

Run the chkpt_db_extracttrail.sql script.

Q22. Which file is required if you’re doing column mapping on the source system only?

Extract parameter file

Target-definitions file

Replicat parameter file

Source-definitions file

Q23. Which of the following is not an initial load method in Oracle GoldenGate?

File to database utility

SQL*Net Load

Direct load

File to Replicat

Q24. What command is used to create the checkpoint table on the target database?

INIT CHECKPOINTTABLE

CREATE TABLE CHECKPOINT

ADD CHECKPOINTTABLE

CONFIGURE CHECKPOINT TABLE

Q25. Replicat Abends with the message “Missing KEYNAME specification”. Which parameter is the cause for this condition?

DECRYPTTRAIL

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.

DECRYPTTRAIL AES128, KEYNAME RepKey

DECRYPTTRAIL AES128, KEYNAME

Q26. Why might you use multiple data pumps for one source trail?

Minimize CPU usage

Send to multiple targets and improve parallelism

Encrypt extract data

Reduce redo generation

Q27. Using the built-in lightweight filtering facility, the Distribution Server allows you to operate simple transformations while dispatching trail files to the Receiver Server.

FALSE

TRUE

Q28. Which of these is a valid Replicat parameter in Oracle GoldenGate?

PASSTHRU

DynamicPortList

RmtHost

SourceDefs

Q29. You want to eliminate the reporting output from processing a Macro. How should you proceed?

Use the optional parameter NOMACROOUTPUT.

Use the optional parameter UNLIST.

Use the optional parameter NOREPORT.

Use the optional parameter NOLIST.

Q30. When using CHECKPOINT BEFORE for EVENTACTIONS, what will an Extract do?

Extract will checkpoint on the starting boundary of the transaction.

Extract will stop at the end of the transaction.

Extract will Abend while processing the transaction.

Extract will checkpoint at the end of the transaction.

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

TRUE

FALSE

Q32. You were assigned to install the Oracle GoldenGate 19c Microservices architecture software. There are three things that need to be done for the installation process: Install the software using the Oracle Universal Installer. Set the necessary environment variables. Deploy an Oracle GoldenGate instance using the configuration assistant, oggc a. What will running the oggca.sh utility do?

Configure the Service Manager and the other Microservices architecture servers.

Create the administration user for the GoldenGate instance.

Create a database user for the GoldenGate instance.

Launch GoldenGate instance wizard to guide you through creating an Extract and a Replicat.

Q33. What is the main advantage of using a data pump Extract?

Trail retention at source for recovery

Faster row compression

Secure REST access

Enables load balancing

Q34. User exits can be used for tables processed by a data pump Extract in passthru mode.

TRUE

FALSE