Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Quiz Questions and Answers

What Are The Different Encryption Levels In Aes?

Answer :
  • 256 bit

Explanation :

abcd

How Do You Add Credentials To The Credential Store?

Answer :
  • ALTER CREDENTIALSTORE ADD USER userid,

Explanation :

abcd

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

Answer :
  • Oracle Goldengate Application Adapters

Explanation :

abcd

My Extract Was Running Fine For A Long Time. All Of A Sudden It Went Down. I Started The Extract Processes After 1 Hour. What Will Happen To My Committed Transactions That Occurred In The Database During Last 1 Hour?

Answer :
  • OGG checkpoint provides the fault tolerance and make sure that the transaction marked for committed is capture and captured only once
  • if the extract went down abnormally, when you start the process again it reads the checkpoint file to provide the read consistency and transaction recovery.

Explanation :

abcd

What Type Of Topology Does Goldenggate Support?

Answer :
  • Unidirectional
  • Bidirectional
  • Peer-to-peer

Explanation :

abcd

Why Is Supplemental Logging Required For Replication?

Answer :
  • This feature is only available for oracle databases in Version 11.2.0.3 or higher.
  • This Capture mode supports extracting data from source databases using compression.
  • Integrated Capture can be configured in an online or downstream mode

Explanation :

abcd

What Type Of Encryption Is Supported In Goldengate?

Answer :
  • Data Encryption using Blow fish
  • Network Encryption
  • Password Encryption

Explanation :

abcd

What Are Some Of The Key Features Of Goldengate 12c?

Answer :
  • RMAN Support for mined archive logs
  • Trigger-less DDL replication

Explanation :

abcd

What Are The Installation Options Available In Ogg 12c?

Answer :
  • Interactive Installation with OUI – Graphical interface
  • Silent Installation with OUI – Command Interface

Explanation :

abcd

How To Configure Credential Store In Ogg 12c?

Answer :
  • By Default Credential Store is is located under “dircrd” directory

Explanation :

abcd