Oracle GoldenGate MCQs with answers Page - 3

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. You are migrating a production Oracle database to a new server with near-zero downtime. Which GoldenGate feature allows users to continue working during migration?

  • (A) Full database export/import
  • (B) Real-time replication using Extract and Replicat
  • (C) Manual data copy
  • (D) Database shutdown migration

A

Arogya • 850 Points
Hero

Q. In a banking system, data must remain available even if the primary data center fails. Which GoldenGate setup is appropriate?

  • (A) Single database instance
  • (B) Active-passive disaster recovery replication
  • (C) Manual daily backup
  • (D) Offline replication

A

Arogya • 850 Points
Hero

Q. An Extract process is running but Replicat is not applying changes. What should you check first?

  • (A) Application UI
  • (B) Trail files existence and Replicat status
  • (C) Database password
  • (D) Frontend server

A

Arogya • 850 Points
Hero

Q. In bidirectional replication, the same record is updating repeatedly in both databases. What is the issue?

  • (A) Data compression
  • (B) Looping/replication conflict
  • (C) Slow disk
  • (D) Memory leak

A

Arogya • 850 Points
Hero

Q. GoldenGate replication delay is increasing. Which metric should you monitor?

  • (A) Database table size
  • (B) Replication lag/latency
  • (C) CPU temperature
  • (D) Number of users

A

Arogya • 850 Points
Hero

Q. A DBA wants to reduce load on the production database while capturing changes. Why is GoldenGate suitable?

  • (A) It locks tables
  • (B) It reads redo/transaction logs instead of tables
  • (C) It deletes old records
  • (D) It stops transactions

A

Arogya • 850 Points
Hero

Q. During migration, target database contains old data plus replicated changes. What is this phase called?

  • (A) Initial load
  • (B) Final cutover
  • (C) Rollback
  • (D) Backup

A

Arogya • 850 Points
Hero

Q. After cutover, users are redirected to the target system. What must be done with replication?

  • (A) Keep same direction
  • (B) Reverse replication or stop source
  • (C) Delete trail files
  • (D) Restart database

A

Arogya • 850 Points
Hero

Q. GoldenGate Replicat process abended due to a missing table on target. What is the solution?

  • (A) Restart server
  • (B) Create the table or map correctly
  • (C) Delete trail file
  • (D) Increase RAM

A

Arogya • 850 Points
Hero

Q. In railway reservation systems, reporting queries slow down the main database. How can GoldenGate help?

  • (A) Disable reporting
  • (B) Replicate data to reporting database
  • (C) Delete users
  • (D) Increase application servers

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.