Practice Questions

Which process is responsible for capturing data changes from the source database?

A. Replicat B. Manager C. Extract D. Collector

What is the purpose of the trail file in Oracle GoldenGate?

A. Store logs for debugging B. Store captured transactional data C. Store configuration parameters D. Store user credentials

Which command is used to start an Extract process in GGSCI?

A. RUN EXTRACT B. START EXTRACT C. ENABLE EXTRACT D. INIT EXTRACT

What is a key benefit of using checkpoint tables?

A. Faster installation B. Improved UI performance C. Recovery and restart capability D. Reduced storage usage

Which replication type allows data to flow in both directions?

A. One-way replication B. Bidirectional replication C. Snapshot replication D. Static replication

Which file contains runtime statistics and execution details?

A. Parameter file B. Trail file C. Report file D. Checkpoint file