Oracle GoldenGate MCQs with answers Page - 6

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. Which OGG command shows process status?

  • (A) INFO ALL
  • (B) START ALL
  • (C) STOP ALL
  • (D) STATUS

A

Arogya • 3.49K Points
Extraordinary

Q. Which process receives trail files on the target server?

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

A

Arogya • 3.49K Points
Extraordinary

Q. What happens if Replicat abends?

  • (A) Database shuts down
  • (B) Replication stops but can restart from checkpoint
  • (C) Trail files deleted
  • (D) Manager stops

A

Arogya • 3.49K Points
Extraordinary

Q. Which parameter file defines OGG process behavior?

  • (A) ggsci
  • (B) GLOBALS
  • (C) prm file
  • (D) dblogin

A

Arogya • 3.49K Points
Extraordinary

Q. GoldenGate supports replication between?

  • (A) Only Oracle databases
  • (B) Only MySQL databases
  • (C) Heterogeneous databases
  • (D) Only same OS

A

Arogya • 3.49K Points
Extraordinary

Q. What does 'lag at checkpoint' in OGG indicate?

  • (A) Network delay
  • (B) Time difference between last committed transaction and current processing position
  • (C) Database server downtime
  • (D) Trail file corruption

A

Arogya • 3.49K Points
Extraordinary

Q. Which command is used to view detailed Extract statistics?

  • (A) INFO EXTRACT
  • (B) STATS EXTRACT
  • (C) VIEW EXTRACT
  • (D) REPORT EXTRACT

A

Arogya • 3.49K Points
Extraordinary

Q. Why is Supplemental Logging required in Oracle GoldenGate?

  • (A) To improve performance
  • (B) To capture sufficient column data for replication
  • (C) To encrypt data
  • (D) To compress trail files

A

Arogya • 3.49K Points
Extraordinary

Q. What will happen if a table has no primary key in OGG replication?

  • (A) Replication fails immediately
  • (B) GoldenGate uses all columns as key
  • (C) GoldenGate ignores the table
  • (D) Database crash occurs

A

Arogya • 3.49K Points
Extraordinary

Q. Which OGG file helps in troubleshooting errors?

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

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.