Oracle GoldenGate MCQs with answers Page - 5

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

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.