Online Access Free 1Z1-947 Practice Test

What is the purpose of a data pump Extract in Oracle GoldenGate?

• A.Reads from local trail and forwards to remote system
• B.Monitors performance metrics
• C.Directly applies changes to target
• D.Encrypts trail files

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

• A.Use the command option ATCSN.
• B.Use the command option AFTERCSN.
• C.Use the command option RESUME.
• D.Use the command option UNTIL CANCEL.

What should be used for disaster tolerance for a database that GoldenGate is using for a source or a target site?

• A.Recovery Manager
• B.Zero database
• C.Active Data Guard
• D.Flashback database

The filter clause provides the ability to include or exclude data to process. What is true with this filter clause: Filter (ON UPDATE, ON DELETE, @Compute(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000)

• A.Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• B.Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• C.Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• D.Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

What parameter manages conflicts between initial load and replication?

• A.CONFLICT_RESOLVER
• B.IGNORE_ERRORS
• C.HANDLECOLLISIONS
• D.RESOLVE_INIT_LOAD