OGG Interview MCQs with answers Page - 3

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. What is the primary purpose of Oracle GoldenGate?

  • (A) Database backup
  • (B) Real-time data replication
  • (C) Database performance tuning
  • (D) Data encryption

A

Arogya • 850 Points
Hero

Q. Which GoldenGate process reads the database transaction logs?

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

A

Arogya • 850 Points
Hero

Q. What is the role of the Replicat process in OGG?

  • (A) Captures data from source DB
  • (B) Applies data to target DB
  • (C) Manages configuration
  • (D) Transfers files

A

Arogya • 850 Points
Hero

Q. Which file contains captured transactions before sending to target?

  • (A) Parameter file
  • (B) Trail file
  • (C) Checkpoint file
  • (D) Report file

A

Arogya • 850 Points
Hero

Q. What is the purpose of the Pump process?

  • (A) Applies transactions
  • (B) Transfers trail files to remote system
  • (C) Manages database connections
  • (D) Compresses data

A

Arogya • 850 Points
Hero

Q. Which GoldenGate component starts and stops all processes?

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

A

Arogya • 850 Points
Hero

Q. GoldenGate uses which database mechanism to capture changes in Oracle?

  • (A) Triggers
  • (B) Stored procedures
  • (C) Redo logs
  • (D) Data dictionary

A

Arogya • 850 Points
Hero

Q. What is a checkpoint in GoldenGate?

  • (A) Backup location
  • (B) Restart position marker
  • (C) Error log
  • (D) Configuration file

A

Arogya • 850 Points
Hero

Q. Which mode allows bidirectional replication?

  • (A) Unidirectional
  • (B) Cascade
  • (C) Active-Active
  • (D) Passive

A

Arogya • 850 Points
Hero

Q. What is the use of the COLMAP clause in OGG?

  • (A) Map tables
  • (B) Map columns between source and target
  • (C) Delete rows
  • (D) Create tables

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