Oracle 1Z0-947 Exam Dumps [2026] Practice Valid Exam Dumps Question
1Z0-947 Dumps - Grab Out For [NEW-2026] Oracle Exam
NEW QUESTION # 13
Invisible columns are columns that are part of a table but not part of the results in a select. When Data Definition Language (DDL) replication is enabled, invisible and virtual columns created in the source environment are replicated in the target environment. What parameter in Extract will exclude invisible columns from replication when using the Integrated Extract?
- A. NOINVISIBLECOLUMNS
- B. EXCLUDEHIDDENCOLUMNS
- C. NOHIDDENCOLUMNS
Answer: B
Explanation:
"Oracle GoldenGate supports replication of invisible columns in Extract.
If you want to exclude them, use the EXCLUDEHIDDENCOLUMNS parameter."
NEW QUESTION # 14
A macro is a built-in automation tool that enables you to call a stored set of processing steps. It can consist of a set of parameters that can be referenced from within a parameter file. What is true about the parameters of a macro?
- A. The parameters in a macro cannot be dynamic parameters.
- B. Macros can only be defined at the source site in the Extract parameter file.
- C. You can reuse a group of parameters in commands and functions by using a macro.
- D. You cannot have macros in a GLOBALS parameter file.
Answer: C
Explanation:
A macro in Oracle GoldenGate lets you define a reusable set of parameters that can be inserted into multiple parameter files or locations, promoting consistency and efficiency in Extract or Replicat configurations.
NEW QUESTION # 15
What is implemented by Oracle GoldenGate to be able to obtain trail files from the source when the source Distribution Server cannot initiate communication with the target where the Receiver Server is?
- A. The Extract will directly send trail files for the Replicat to receive and apply changes.
- B. A secured port must be implemented and opened by the target to enable the source Distribution Server to be able to initiate communication with the target's Receiver Server.
- C. A Receiver Server can pull trail files from Distribution Server using a single port for Reverse proxy.
- D. Microservices Architecture Authentication will initiate communication for the Distribution Server.
Answer: C
Explanation:
In Oracle GoldenGate Microservices Architecture, when the source Distribution Server cannot initiate outbound communication (e.g., due to firewall or network restrictions), the Receiver Server on the target can be configured to pull trail files using Reverse Proxy mode - establishing a single, secure inbound connection.
NEW QUESTION # 16
What Oracle GoldenGate microservices component is used to handle all incoming trail files?
- A. Administration server
- B. Receiver server
- C. Service Manager
- D. Trail File server
Answer: B
Explanation:
The Receiver Server is the GoldenGate Microservices component that handles all incoming trail files, replacing the need for multiple Collectors on the target side. It supports WebSockets and other protocols to securely receive data from the Distribution Server
NEW QUESTION # 17
Replicat Abends with the message "Missing KEYNAME specification". Which parameter is the cause for this condition?
- A. DECRYPTTRAIL
- B. 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.
- C. DECRYPTTRAIL AES128, KEYNAME RepKey
- D. DECRYPTTRAIL AES128, KEYNAME
Answer: B
NEW QUESTION # 18
You have a table that has a primary key as well as an additional unique key. Failing to consistently identify a row will result in an error during conflict resolution. Which option solves this?
- A. Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
- B. Add unique indexes to the table to resolve the conflict.
- C. Use the SQLEXEC feature to handle errors and resolve the conflict.
- D. Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.
Answer: B
Explanation:
Oracle GoldenGate must consistently identify rows during replication using a primary or unique key. If row identification fails, adding or enforcing a unique index is the correct way to resolve the issue-not relying on collision or conflict-handling features.
NEW QUESTION # 19
Which parameter gives more accurate timing for lag statistics?
- A. TCPSourceTimer
- B. DynamicResolution
- C. CacheMgr
Answer: A
Explanation:
TCPSourceTimer improves lag timing accuracy.
NEW QUESTION # 20
Proper prerequisite planning will ensure a successful Initial Load. To ensure not to miss any data, before starting any instantiation method, it is important you verify that all open transactions that existed when Extract was started are completed. Which two sources do you use to see that transactions no longer exist before beginning instantiation?
- A. GV$TRANSACTION
- B. GG$TRANSACTION
- C. DBA$TRANSACTION
- D. V$TRANSACTION
Answer: A,D
Explanation:
GV$TRANSACTION - shows active transactions across all RAC instances
EXCLUDEHIDDENCOLUMNS
NEW QUESTION # 21
When should the KeyCols parameter be used?
- A. In addition to the unique index
- B. In addition to the primary key
- C. To define a substitute primary key
Answer: C
Explanation:
Use KEYCOLS when no primary key exists.
NEW QUESTION # 22
Integrated delivery works only with trail files from integrated capture.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Integrated delivery can use trail files from classic or integrated capture.
NEW QUESTION # 23
You must locate the next good record header in a Logdump file. How should you do this?
- A. Logdump > SCANFORHEADER
- B. Logdump > SCANFORENDTRANS
- C. Logdump > SCANFORGHDR
- D. Logdump > GHDR ON
Answer: A
Explanation:
In Oracle GoldenGate's Logdump utility, to locate the next valid (good) record header within a trail file, you use: text Copy Edit SCANFORHEADER This command scans forward until it finds the next readable record header, which is useful for troubleshooting corrupted trail files or resynchronizing log parsing.
NEW QUESTION # 24
What Oracle GoldenGate component sends trail files over the network to the Receiver Server?
- A. The Trail File Server
- B. The Extract
- C. The Distribution Server on the source
- D. The GoldenGate source Data Pump
Answer: C
Explanation:
"A Distribution Service process will read the trail file and send it across the network to a waiting Receiver Service process..."
NEW QUESTION # 25
Cache and queue statistic drill-downs are available for both Extract and Replicat groups.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Drill-downs are available only for Extract groups.
NEW QUESTION # 26
What is the purpose of the GoldenGate Initial Load?
- A. To stream change data to a target database
- B. To synchronize data in the source and target databases
- C. To create the target database objects
- D. To carry out Performance Load Testing
Answer: B
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 # 27
Oracle GoldenGate writes OS-level errors to:
- A. System log
- B. Event log
- C. Process report
- D. Discard file
Answer: A
Explanation:
System log is where OS-level errors are recorded.
NEW QUESTION # 28
Which commands are used to create and start a Replicat group?
- A. ADD REPLICAT, START REPLICAT, EDIT PARAMS
- B. CREATE REPLICAT, RUN REPLICAT
- C. INIT REPLICAT, BEGIN APPLY
- D. BUILD REPLICAT, LAUNCH APPLY
Answer: A
Explanation:
These are the standard commands used to define and activate a Replicat group.
NEW QUESTION # 29
You must provide credentials, like a username and password, to access the database credentials store where the actual user credentials are stored. The credential store is preferable to using the database username and password in the commands or the parameter file. What may you use rather than a user ID and password, in the parameter file, for the Extract or Replicat to provide credentials for access to the source or target database?
- A. Single Sign On
- B. Oracle SID
- C. UserReplicationUser
- D. UserIDAlias
Answer: D
Explanation:
You can use UserIDAlias in the parameter file to reference credentials securely stored in the Oracle GoldenGate credential store, avoiding plain-text usernames and passwords.
NEW QUESTION # 30
The Integrated Extract can use the LogMiner components to collectively read and format the logical change records and create trail entries in the trail file. Which of the following is not a component of the LogMiner?
- A. Converter
- B. Reader
- C. Builder
- D. Preparer
Answer: A
Explanation:
In Oracle LogMiner (used by Integrated Extract), the core components are Reader, Preparer, and Builder - they work together to read redo logs, extract change records, and prepare them for trail file writing. Converter is not a valid LogMiner component.
NEW QUESTION # 31
Which is an invalid combination for EVENTACTIONS with options?
- A. EVENTACTIONS (CHECKPOINT BOTH, IGNORE)
- B. EVENTACTIONS (CHECKPOINT BOTH, STOP)
- C. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
- D. EVENTACTIONS (CHECKPOINT AFTER, ABORT)
Answer: A
Explanation:
The combination CHECKPOINT BOTH with IGNORE is invalid because IGNORE tells Replicat to skip the transaction, while CHECKPOINT BOTH implies a complete apply and checkpoint - which contradicts the action of ignoring the transaction.
NEW QUESTION # 32
......
1Z0-947 Exam Dumps PDF Guaranteed Success with Accurate & Updated Questions: https://www.examsreviews.com/1Z0-947-pass4sure-exam-review.html
Pass 1Z0-947 Exam - Real Test Engine PDF with 147 Questions: https://drive.google.com/open?id=1WKsaCHr-huf8eebTMt1qnhPma_Zu0Ah6