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

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

Q. Which GoldenGate process reads the database transaction logs?

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

A

Arogya • 3.49K Points
Extraordinary

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

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

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

A

Arogya • 3.49K Points
Extraordinary

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

Q. Which GoldenGate component starts and stops all processes?

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

A

Arogya • 3.49K Points
Extraordinary

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

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

A

Arogya • 3.49K Points
Extraordinary

Q. What is a checkpoint in GoldenGate?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Which mode allows bidirectional replication?

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

A

Arogya • 3.49K Points
Extraordinary

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.