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

Q. Which GoldenGate component transfers trail files across servers?

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

A

Arogya • 3.49K 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.49K 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.49K 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.49K 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.49K 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.49K 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.49K 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.49K 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.49K 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

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.