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

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

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

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

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

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

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

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

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

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

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.