Oracle GoldenGate MCQs with answers Page - 8

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

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

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

A

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

Q. Which command shows replication lag time?

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

A

Arogya • 1K 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 • 1K 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

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.