OGG Interview MCQs with answers Page - 4

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

Q. Which OGG command shows process status?

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

A

Arogya • 3.19K Points
Extraordinary

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

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

A

Arogya • 3.19K 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.19K Points
Extraordinary

Q. Which parameter file defines OGG process behavior?

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

A

Arogya • 3.19K 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.19K 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.19K 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.19K 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.19K 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.19K Points
Extraordinary

Q. Which OGG file helps in troubleshooting errors?

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

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