Online Access Free 1z1-447 Exam Questions

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

• A.Use the optional parameterNOREPORT.
• B.Use the optional parameterNOMACROOUTPUT.
• C.Use the optional parameterUNLIST.
• D.Use the optional parameterNOLIST.

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 theCOLMAPoption in theMAPparameter.
• B.Do not specify those columns in theADD TRANDATAcommand.
• C.Use theFILTERoption in theMAPparameter.
• D.Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Which three describe a valid OGG Event Action?

• A.Stop the process
• B.Purge old trail files
• C.Run a shell command
• D.Write a checkpoint before and/or after writing the record to the trail.

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 theMAXTRANSOPSparameter.
• B.It is caused by the thread with the highest thread ID applying barrier transactions.
• C.It is caused by barrier transactions in a Coordinated Replicat.
• D.It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP
  statements.

What file must be configured in order to use custom encryption keys?

• A.GLOBALS
• B.CUSTKEYS
• C.ENCKEYS
• D.ENCRYPT