OGG Interview MCQs with answers Page - 6

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 • 1.97K Points
Master

Q. Replicat ABENDED with error ORA-00001: unique constraint violated. What is the MOST likely reason?

  • (A) Network failure
  • (B) Duplicate record already exists on target
  • (C) Trail file missing
  • (D) Extract stopped

A

Arogya • 1.97K Points
Master

Q. Which immediate command should you run first after Replicat ABEND?

  • (A) DELETE REPLICAT
  • (B) STOP MANAGER
  • (C) VIEW REPORT <replicat>
  • (D) RESTART DATABASE

A

Arogya • 1.97K Points
Master

Q. Extract lag suddenly increased to several hours. What should you check FIRST?

  • (A) Database redo generation rate
  • (B) CPU usage of client system
  • (C) Internet browser cache
  • (D) Database user password

A

Arogya • 1.97K Points
Master

Q. Trail file disk space becomes full. What will happen?

  • (A) Replication continues normally
  • (B) Extract process will ABEND
  • (C) Database shutdown
  • (D) Manager stops automatically

A

Arogya • 1.97K Points
Master

Q. Which parameter helps to skip a problematic transaction and continue replication?

  • (A) SKIPTRANSACTION
  • (B) IGNOREERROR
  • (C) HANDLECOLLISIONS
  • (D) AUTORESTART

A

Arogya • 1.97K Points
Master

Q. After initial load, duplicate rows are appearing in target. What was probably forgotten?

  • (A) TRUNCATE target tables
  • (B) Restart manager
  • (C) Delete trail files
  • (D) Restart database

A

Arogya • 1.97K Points
Master

Q. Extract is running but Replicat is not receiving data. Which component might be down?

  • (A) Manager
  • (B) Data Pump
  • (C) Oracle Listener
  • (D) RMAN

A

Arogya • 1.97K Points
Master

Q. Which command shows replication lag time?

  • (A) INFO EXTRACT, DETAIL
  • (B) LAG EXTRACT
  • (C) STATS MANAGER
  • (D) CHECK DB

A

Arogya • 1.97K Points
Master

Q. Target database is slower than source. What will happen?

  • (A) Extract lag increases
  • (B) Replicat lag increases
  • (C) Manager stops
  • (D) Trail file deleted

A

Arogya • 1.97K Points
Master

Q. Manager process is down. What is the impact?

  • (A) Replication continues forever
  • (B) No new Extract/Replicat processes can be started or restarted
  • (C) Database crash
  • (D) Trail files deleted

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