Oracle GoldenGate MCQs with answers Page - 4

Here, you will find a collection of MCQ questions on Oracle GoldenGate. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Arogya • 850 Points
Hero

Q. Which GoldenGate component transfers trail files across servers?

  • (A) Manager
  • (B) Data Pump Extract
  • (C) Replicat
  • (D) Collector

A

Arogya • 850 Points
Hero

Q. You want to replicate only selected tables instead of the entire database. What should you configure?

  • (A) TABLE and MAP parameters
  • (B) Database shutdown
  • (C) Full export
  • (D) OS backup

A

Arogya • 850 Points
Hero

Q. Replication stopped due to large transactions filling memory. Which configuration helps?

  • (A) Batch delete
  • (B) Checkpoint and trail management
  • (C) Restart application
  • (D) Delete database

A

Arogya • 850 Points
Hero

Q. A company wants Oracle to MySQL replication. Is GoldenGate suitable?

  • (A) No
  • (B) Yes, it supports heterogeneous replication
  • (C) Only Oracle to Oracle
  • (D) Only SQL Server

A

Arogya • 850 Points
Hero

Q. In payment systems, duplicate transaction must be avoided. Which GoldenGate feature helps?

  • (A) Conflict detection and resolution
  • (B) Data deletion
  • (C) Table locking
  • (D) Manual checks

A

Arogya • 850 Points
Hero

Q. GoldenGate Manager process is down. What happens?

  • (A) Replication stops completely
  • (B) Extract and Replicat may not restart or be monitored
  • (C) Database crashes
  • (D) Tables deleted

A

Arogya • 850 Points
Hero

Q. What is checkpointing in GoldenGate?

  • (A) Backup database
  • (B) Saving last processed transaction position
  • (C) Deleting logs
  • (D) Restarting service

A

Arogya • 850 Points
Hero

Q. You need zero data loss during failover. What configuration is best?

  • (A) Asynchronous replication
  • (B) Synchronous or low-latency replication
  • (C) Weekly backup
  • (D) Manual copy

A

Arogya • 850 Points
Hero

Q. Trail files keep growing and disk is full. What should be done?

  • (A) Delete database
  • (B) Enable trail file purging and checkpoints
  • (C) Restart OS
  • (D) Increase CPU

A

Arogya • 850 Points
Hero

Q. Why is GoldenGate used in microservices architecture?

  • (A) To replace APIs
  • (B) To synchronize databases of multiple services
  • (C) To build frontend
  • (D) To compile Java

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.