10 free sample questions from a bank of 56, with the correct answers and explanations. No signup required — start practising right now.
1You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?
Oracle Goldengate for Big Data
Oracle Goldengate Application Adapters
Oracle Goldengate Veridata
Oracle Data Integrator Adapters
Answer: B
2Which statement is valid for DDL replication?
GoldenGate User Exits are not supported for DDL.
Source and target objects can be different.
Target objects can be different from source when using SOURCEDEFS in Replicat.
It can use WILDCARDRESOLVE IMMEDIATE.
Answer: B
3You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?
The incorrect version of GoldenGate was installed for your CPU architecture.
A license key must be applied first.
GoldenGate Manager was not started first.
The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.
Answer: A
4Identify the correct statement regarding Trails.
Extract and Pump are different OS level executable binary files.
Extracts cannot perform filtering, mapping, and transformations.
RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
Extract is typically used to produce local trail files over a TCP/IP connection.
Answer: B
5Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.
Run the chkpt_db_extracttrail.sql script.
Run the chkpt_db_create.sql script.
Use the ADD Extract Trail command.
Use the INFO REPLICAT command with the SHOWCH option.
Use the ADD CHECKPOINTTABLE command.
Answer:
6You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-todatabase utility. How should you configure GoldenGate in order to accomplish this?
Configure Replicat with the FORMATASCII SQLLOADER OPTION.
Configure Extract with the FORMATSQL SQLLOADER OPTION.
Configure Extract with the FORMATASCII SQLLOADER OPTION.
Configure Replicat with the FORMATXML OPTION.
Answer: C
7Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after
Extract has stopped?
Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
Answer: C
8Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?
ENABLE_GOLDENGATE_REPLICATION=true
ENABLE_STREAMS_REPLICATION=true
Configure the STREAMS_POOL_SIZE database parameter
ENABLE_DATABASE_REPLICATION=true
Answer: A
9How should you configure Replicat to control how errors are handled in one-way replication?
Use REPERROR in the Replicat parameter file.
Use HANDLECOLLISION in the Replicat parameter file.
Use Conflict Detection and Resolution in the Replicat parameter file.
Use MAPEXCEPTION in the Replicat parameter file.
Answer: A
10You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?