Quiz  /  Oracle Certification Bank PO MCQ Questions With Answers

  • 1. 
    Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?Example: 1 INFO EXTRACT Example: 2 INFO EXTRACT , DETAILExample: 3 INFO EXTRACT , SHOWCH

  • a) Example 2 only
  • b) Example 3 only
  • c) Examples 1 and 3
  • d) Examples 1 and 2

  • 2. 
    If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

  • a) Manager
  • b) Extract
  • c) Replicat
  • d) Both Extract and Replicat

  • 3. 
    What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

  • a) KEYGEN file in the GoldenGate data location
  • b) COBGEN file in the GoldenGate installation location
  • c) GGSKEY file in the GoldenGate data location
  • d) GGSKEY file in the GoldenGate installation location
  • e) ENCKEYS file in the GoldenGate installation location

  • 4. 
    Which process(es) maintain a checkpoint file?

  • a) Extract only
  • b) Replicat only
  • c) Both Extract and Replicat
  • d) Server collector

  • 5. 
    When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture?

  • a) The middle-tier capture server has the same endian order and bit width
  • b) The middle-tier server must have a database installed on it
  • c) GoldenGate only supports Windows or Linux on the middle-tier server
  • d) GoldenGate only supports UNIX on the middle-tier server
Report Question
warning
access_time
  Time