OGG Interview MCQs with answers Page - 1

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. 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

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