Which three describe a valid OGG Event Action?

Which three describe a valid OGG Event Action? A. Stop the process B. Write a checkpoint before and/or after writing the record to the trail. C. Run a shell command D. Purge old trail files Explanation:In reference guide, page 312, Syntax EVENTACTIONS ([STOP | ABORT | FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG [INFO | WARNING]][REPORT][ROLLOVER][SHELL <command>][TRACE <trace file> […]

Read More

What parameters should you use?

You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements includeusing a custom encryption key and advanced encryption standard (AES), and you have created an ENCKEYS fileWhat parameters should you use? A. This feature is not supported in oracle goldenGate 10. B. […]

Read More

Which translations are captured if you ADD EXTRACT BEGIN now 1:

Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START EXTRACT at 2:00 p.m.? A. Transactions started on or after 1:00 p.m. B. Transactions started on or after 2:00 p.m. C. Transactions started before 1:00 p.m and committed after 1:00 p.m. D. Transactions started before 1:00 p.m and committed after 2:00 […]

Read More

What is you best strategy to recover From this?

You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this? A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files. B. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to […]

Read More

What is likely to happen if one of her source tables in

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her sourcetables includes LOB data? A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards. B. The Extract will revert to single-row fetch mode for all tables. […]

Read More