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 • 3.19K Points
Extraordinary

Q. Which GoldenGate component transfers trail files across servers?

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

A

Arogya • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

Q. What is checkpointing in GoldenGate?

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

A

Arogya • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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 • 3.19K Points
Extraordinary

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