Free Oracle 1Z0-947 Exam Dumps Questions & Answers

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

• A.  Use the optional parameter NOLIST.
• B.  Use the optional parameter UNLIST.
• C.  Use the optional parameter NOREPORT.
• D.  Use the optional parameter NOMACROOUTPUT.

What is a trusted point in a GoldenGate deployment?

• A.  An access point that you can trust to be a safe connection
• B.  A high level of security and protection system that is designed against various types of threats, including malware, hacking, and attacks
• C.  The one root certificate authority (rootCA) that is used for signing all certificates across all deployments
• D.  Security keys to provide secure online authentication

Which parameter is typically used with data pumps unless transformation is needed?

• A.  PASSTHRU
• B.  ASSUMETARGETDEFS
• C.  TrailFile
• D.  Map

With BATCHSQL enabled, what causes a Replicat to use normal mode operation?

• A.  Statements that cause errors
• B.  When BATCHSQL and GROUPTRANSOPS coexist
• C.  Statements with rows between 8k and 24k in length
• D.  When server memory < 8 GB

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

• A.  It is caused by the use of the MAXTRANSOPS parameter.
• B.  It is caused by barrier transactions in a Coordinated Replicat.
• C.  It is caused by the thread with the highest thread ID applying barrier transactions.
• D.  It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.