OGG Interview MCQs with answers Page - 2

You will find multiple-choice questions (MCQs) related to #OGG Interview here. Go through these questions to prepare effectively for your upcoming exams and interviews.

To view the correct answer for any question, simply click the "Show Answer" button.

Have a question to share? Click on "Add Question" to contribute!

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

Browse More Tags

Click on tag to learn MCQs of that tag.
What's Tag

As you may know, questions are organized under broad categories. Each category can include various types of questions. For example, the "History" category might contain questions about the Revolt of 1857, Shivaji Maharaj, Ancient History, Buddhism, and more.

To further refine this organization, we've introduced tags, which act as sub-categories to group questions more specifically.

Verified users can add tags to any question. If you have any suggestions regarding this system, we'd love to hear from you. Contact Us

Learn More