Jan-2026 Oracle 1Z1-947 Actual Questions and 100% Cover Real Exam Questions
1Z1-947 Free Exam Questions and Answers PDF Updated on Jan-2026
NEW QUESTION # 14
You can connect to the Receiver Server to manage (start and stop) the configured data paths.
- A. TRUE
- B. FALSE
Answer: A
Explanation:
Receiver Server can start/stop data paths.
NEW QUESTION # 15
Which tools would you use to determine if all Oracle GoldenGate processes are up and running?
- A. Process report
- B. tcpers
- C. GGSCI
- D. CMDSEC
- E. Oracle GoldenGate Monitor
Answer: A,C,E
Explanation:
Use GGSCI, process reports, or Monitor to check running processes.
NEW QUESTION # 16
Which parameter is used to identify the remote target system in Oracle GoldenGate?
- A. HostName
- B. TargetTrail
- C. Map
- D. RmtHost
Answer: D
NEW QUESTION # 17
Initial Load is a process of extracting data records from the source database and loading those records onto the target database. There are many advantages in using GoldenGate to obtain the data from the source and load the records onto the target. What describes the advantage of continuing to make data changes on the source database while loading data onto the target database?
- A. Enable change delivery to handle collisions with initial load.
- B. Enable the LGWR to indicate in the transaction log when initial load commenced.
- C. Enable data changes on source tables without locking tables.
- D. Enable Extract to indicate in the trail file when initial load commenced.
Answer: C
Explanation:
"Oracle GoldenGate can perform a one-time initial load while the source tables remain online and active. You do not need to lock the source tables during the load. Oracle GoldenGate tracks ongoing changes with Change Data Capture (CDC) and applies them after the load completes."
NEW QUESTION # 18
Table A has (ColA number Primary Key, ColB char(2), ColC varchar(10)) with one record with the following data: (1, 'AB', 'TestData') What will Extract capture by default for an update on ColC?
- A. After Image (1, 'AB', 'NewValue')
- B. After Image (1, 'NewValue')
- C. Before Image (1, 'TestData') + After Image (1, 'NewValue')
- D. Before Image (1, 'AB', 'TestData') + After Image (1, 'AB', 'NewValue')
Answer: D
Explanation:
By default, Oracle GoldenGate Extract captures both the before image and the after image of an update, including all key and updated columns, when:
* GETUPDATEBEFORES is enabled (default in many Extract configurations).
* UPDATERECORDFORMAT COMPACT (default) includes both before and after values in a single record.
NEW QUESTION # 19
Which capability does GoldenGate support?
- A. Asynchronous Capture and Delivery of committed DML transactions
- B. Synchronous transaction Capture from application interfaces
- C. Two-phase commit operations from application interfaces
- D. File-based Capture
Answer: A
Explanation:
Oracle GoldenGate captures committed DML changes asynchronously from database redo or transaction logs and delivers them to the target system asynchronously. This minimizes overhead and avoids interfering with live transactions.
NEW QUESTION # 20
What is the purpose of an Obey file in Oracle GoldenGate?
- A. Debugging configuration
- B. Encryption key store
- C. An ASCII file
- D. Temporary trail storage
Answer: C
Explanation:
An ASCII file containing command sequences for reuse (similar to a script)
NEW QUESTION # 21
What is a DiscardFile not used for?
- A. Replacing a trail file on the target system
- B. File for rejected Replicat data
- C. File for rejected Extract data
Answer: A
Explanation:
DiscardFile does not replace trail files; it logs rejected records.
NEW QUESTION # 22
How should you specify the data source for a secondary Extract functioning as a Data Pump?
- A. SOURCEISSTABLE
- B. SOURCEISTRAIL
- C. EXTTRAILSOURCE
- D. LOCTRAILSOURCE
Answer: C
Explanation:
For a secondary Extract functioning as a Data Pump, you should specify the data source using EXTTRAILSOURCE. This parameter tells GoldenGate to use the local trail file (created by the primary Extract) as the source for the data pump.
NEW QUESTION # 23
With BATCHSQL enabled, what causes a Replicat to use normal mode operation?
- A. Statements that cause errors
- B. When server memory < 8 GB
- C. Statements with rows between 8k and 24k in length
- D. When BATCHSQL and GROUPTRANSOPS coexist
Answer: C
Explanation:
When BATCHSQL is enabled in Oracle GoldenGate Replicat, it tries to optimize performance by grouping multiple SQL statements and applying them in batches using array operations. However, if an error occurs during the execution of a batched group of statements, GoldenGate automatically switches the Replicat into "normal mode" (i.e., one-by-one row apply) for that transaction to allow better error handling and diagnostics.
NEW QUESTION # 24
You find that an Extract's recovery time increases. What caused it?
- A. There is no oldest open (uncommitted) transaction.
- B. The difference between the start of the oldest open (uncommitted) transaction and current read position in the transaction log stored in the checkpoint file is large.
- C. The current read position (RBA) is less than the oldest open (uncommitted) transaction position.
- D. The oldest open (uncommitted) transaction is small.
Answer: B
Explanation:
When the difference between the oldest open transaction's start and the current read position is large, Extract must scan more log data, increasing recovery time.
NEW QUESTION # 25
Which tools would you use to determine if all Oracle GoldenGate processes are up and running?
- A. Process report
- B. tcpers
- C. GGSCI
- D. CMDSEC
- E. Oracle GoldenGate Monitor
Answer: A,C,E
Explanation:
Use GGSCI, process reports, or Monitor to check running processes.
NEW QUESTION # 26
What is the main advantage of using a data pump Extract?
- A. Enables load balancing
- B. Faster row compression
- C. Trail retention at source for recovery
- D. Secure REST access
Answer: C
Explanation:
It allows recovery if the network or target system fails by maintaining a local trail.
NEW QUESTION # 27
Which of the following issues can prevent Replicat from advancing?
- A. The Extract name is incorrect
- B. The trail name is incorrect
- C. The Stats Replicat command must be run
Answer: B
Explanation:
An incorrect trail name stops Replicat from progressing.
NEW QUESTION # 28
Key names and values can be stored in:
- A. DefsFile
- B. ENCKEYS
- C. GLOBALS
- D. SourceDefs
Answer: B
Explanation:
ENCKEYS stores key-value pairs for encryption.
NEW QUESTION # 29
What is the purpose of a data pump Extract in Oracle GoldenGate?
- A. Encrypts trail files
- B. Reads from local trail and forwards to remote system
- C. Monitors performance metrics
- D. Directly applies changes to target
Answer: B
Explanation:
It allows recovery if the network or target system fails by maintaining a local trail.
NEW QUESTION # 30
How is Oracle GoldenGate different from simple replication?
- A. It supports only batch-based replication
- B. It uses trigger-based data capture
- C. It only supports homogeneous databases
- D. It uses log-based CDC and supports real-time, heterogeneous replication
Answer: D
Explanation:
GoldenGate captures changes directly from redo/transaction logs and supports various databases in real-time.
NEW QUESTION # 31
Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
EncryptTrail is not the only way to encrypt trail files.
NEW QUESTION # 32
A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?
- A. Use the FILTER option in the MAP parameter.
- B. Do not specify those columns in the ADD TRANDATA command.
- C. Use the COLMAP option in the MAP parameter.
- D. Use the COLS and COLSEXCEPT options in the TABLE parameter.
Answer: D
Explanation:
To prevent sensitive data from being replicated, you should use the COLS and COLSEXCEPT options in the TABLE parameter. These options allow you to explicitly include or exclude specific columns from the replication process, ensuring that sensitive data is not transferred to the target database.
NEW QUESTION # 33
How is Integrated Capture different from Classic Capture?
- A. Integrated Capture is different because it captures processes to integrate with an application server.
- B. Integrated Capture is different because it connects directly to the inbound server to apply transactions.
- C. Integrated Capture is different because it receives Logical Change Records (LCRs) directly from a database logmining server.
- D. Integrated Capture is different because it automatically configures the Capture process of GoldenGate.
Answer: C
Explanation:
The main difference between Integrated and Classic Capture in Oracle GoldenGate lies in how changes are captured from the database. Integrated Capture uses a database logmining server to receive Logical Change Records (LCRs) directly, while Classic Capture directly reads redo log files.
NEW QUESTION # 34
A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?
- A. From Cloud Shell with REST APIs
- B. From the Service Manager home page
- C. In GGSCI with GoldenGate commands
- D. At OS prompt with run preceding the GoldenGate commands
Answer: B
Explanation:
In Oracle GoldenGate Microservices Architecture, the Service Manager UI is the recommended and primary interface to create a Distribution Path using the Distribution Server. This method is officially documented and intended for simplified management.
NEW QUESTION # 35
You are concerned that the process report generation in your production environment will become too large and not contain useful statistics.
- A. GoldenGate automatically generates a new report when the processes start.
- B. Use the parameter REPORTROLLOVER.
- C. Use the parameter REPORT.
- D. Use the ADD EXTTRAIL command option MEGABYTES.
Answer: B
Explanation:
The REPORTROLLOVER parameter lets you automatically rotate and archive GoldenGate process report files based on size, time, or process restarts, preventing them from growing too large and cluttering with old data.
NEW QUESTION # 36
What is the purpose of the GoldenGate Initial Load?
- A. To stream change data to a target database
- B. To create the target database objects
- C. To synchronize data in the source and target databases
- D. To carry out Performance Load Testing
Answer: C
Explanation:
The Initial Load in Oracle GoldenGate is used to: Populate the target database with a baseline copy of data from the source Ensure that both source and target are in sync before real-time replication begins After this load, GoldenGate can start streaming only ongoing changes
NEW QUESTION # 37
You made changes to the GLOBALS parameter file using an editor on the OS. After saving your changes, you noticed the changes did not take effect. What would be the reason for this?
- A. You did not make changes on the OS logged in as the GoldenGate Administrator user.
- B. You did not stop all replication processes running in so the changes can take effect.
- C. You did not MGR so the changes can take effect.
- D. You did not restart GGSCI.
Answer: D
Explanation:
This is because GLOBALS parameters are read only at GGSCI startup, unlike other dynamic parameter files (e.g., Extract or Replicat configs). ?? So without restarting GGSCI, your changes won't be recognized.
NEW QUESTION # 38
Oracle GoldenGate writes OS-level errors to:
- A. Event log
- B. Process report
- C. Discard file
- D. System log
Answer: D
Explanation:
System log is where OS-level errors are recorded.
NEW QUESTION # 39
......
Oracle 1Z1-947 Real 2026 Braindumps Mock Exam Dumps: https://prep4sure.examtorrent.com/1Z1-947-exam-papers.html
