Oracle Certification Bank PO MCQ Questions With Answers Quiz Questions

MCQ Mojo

Quiz Guides

Class 1 Class 2 Class 3 Class 4 Class 5 Class 6 Class 7 Class 8 Class 9 Class 10 Class 11 Class 12

Quiz Guides

CBSE

Class 1 Class 2 Class 3 Class 4 Class 5 Class 6 Class 7 Class 8 Class 9 Class 10 Class 11 Class 12

Toggle dark mode

Home › Quiz › Oracle Certification Bank PO MCQ Questions With Answers

1/5

0:00

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 a) Example 2 only B b) Example 3 only C c) Examples 1 and 3 D 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 a) Manager B b) Extract C c) Replicat D 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 a) KEYGEN file in the GoldenGate data location B b) COBGEN file in the GoldenGate installation location C c) GGSKEY file in the GoldenGate data location D d) GGSKEY file in the GoldenGate installation location 5 e) ENCKEYS file in the GoldenGate installation location

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

A a) Extract only B b) Replicat only C c) Both Extract and Replicat D 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 a) The middle-tier capture server has the same endian order and bit width B b) The middle-tier server must have a database installed on it C c) GoldenGate only supports Windows or Linux on the middle-tier server D d) GoldenGate only supports UNIX on the middle-tier server

MCQ Mojo

Free chapter-wise MCQ practice with instant answers and explanations for CBSE classes 6–12 — plus timed mock tests. Learn smarter, score higher.