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

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

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

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

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

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

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

A

Arogya • 3.49K Points
Extraordinary

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

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

Q. Which command shows replication lag time?

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

A

Arogya • 3.49K Points
Extraordinary

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

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.