OGG Interview MCQs with answers Page - 5

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 command is used to start a Replicat process?

  • (A) RUN REPLICAT
  • (B) START REPLICAT
  • (C) BEGIN REPLICAT
  • (D) EXEC REPLICAT

A

Arogya • 3.19K Points
Extraordinary

Q. What is the function of HANDLECOLLISIONS parameter?

  • (A) Avoid duplicate data during initial load
  • (B) Improve performance
  • (C) Encrypt replication
  • (D) Delete old records

A

Arogya • 3.19K Points
Extraordinary

Q. Which process writes data into trail files?

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

A

Arogya • 3.19K Points
Extraordinary

Q. What is a 'heartbeat table' in OGG?

  • (A) Backup table
  • (B) Latency monitoring table
  • (C) Temporary table
  • (D) Audit table

A

Arogya • 3.19K Points
Extraordinary

Q. Which scenario increases Replicat lag the most?

  • (A) Fast network
  • (B) Large transactions
  • (C) Small commits
  • (D) High CPU

A

Arogya • 3.19K Points
Extraordinary

Q. What does 'ABEND' mean in OGG?

  • (A) Normal shutdown
  • (B) Abnormal end of process
  • (C) Network timeout
  • (D) Checkpoint reset

A

Arogya • 3.19K Points
Extraordinary

Q. Which file stores OGG environment settings globally?

  • (A) GLOBALS
  • (B) PARAM
  • (C) REPORT
  • (D) TRAIL

A

Arogya • 3.19K Points
Extraordinary

Q. What is 'Integrated Replicat'?

  • (A) OS-level replication
  • (B) Replicat running inside Oracle database using parallel apply
  • (C) Manual replication
  • (D) Network replication

A

Arogya • 3.19K Points
Extraordinary

Q. Which clause is used to map source and target tables?

  • (A) TABLEMAP
  • (B) MAP
  • (C) CONNECT
  • (D) SYNC

A

Arogya • 3.19K Points
Extraordinary

Q. Which command shows Replicat errors in GGSCI?

  • (A) VIEW REPORT
  • (B) SHOW ERROR
  • (C) ERROR LOG
  • (D) CHECK REPLICAT
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