Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-447 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

A The incorrect version of GoldenGate was installed for your CPU architecture.
B A license key must be applied first.
C GoldenGate Manager was not started first.
D The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.

Question 4

Identify the correct statement regarding Trails.

A Extract and Pump are different OS level executable binary files.
B Extracts cannot perform filtering, mapping, and transformations.
C RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
D Extract is typically used to produce local trail files over a TCP/IP connection.

Question 5

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

A Run the chkpt_db_extracttrail.sql script.
B Run the chkpt_db_create.sql script.
C Use the ADD Extract Trail command.
D Use the INFO REPLICAT command with the SHOWCH option.
E Use the ADD CHECKPOINTTABLE command.

Question 6

You 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?

A Configure Replicat with the FORMATASCII SQLLOADER OPTION.
B Configure Extract with the FORMATSQL SQLLOADER OPTION.
C Configure Extract with the FORMATASCII SQLLOADER OPTION.
D Configure Replicat with the FORMATXML OPTION.

Question 7

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after
Extract has stopped?

A Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
B Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
C Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
D Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.

Question 8

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

A ENABLE_GOLDENGATE_REPLICATION=true
B ENABLE_STREAMS_REPLICATION=true
C Configure the STREAMS_POOL_SIZE database parameter
D ENABLE_DATABASE_REPLICATION=true

Question 9

How should you configure Replicat to control how errors are handled in one-way replication?

A Use REPERROR in the Replicat parameter file.
B Use HANDLECOLLISION in the Replicat parameter file.
C Use Conflict Detection and Resolution in the Replicat parameter file.
D Use MAPEXCEPTION in the Replicat parameter file.

Question 10

You 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?

A Tables set with nologging
B Tables with Large Object (LOB) data types
C Tables that have conflicts
D Triggers and sequences

Question 11

If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

A Manager
B Replicat
C Extract
D Extract and Replicat

Question 12

You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

A the number of concurrent users
B disk space
C system memory
D the number of compound keys on the source tables

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 56

1 2 3

→

Know a question that should be here? Contribute to this exam

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

A Oracle Goldengate for Big Data
B Oracle Goldengate Application Adapters
C Oracle Goldengate Veridata
D Oracle Data Integrator Adapters

Which statement is valid for DDL replication?

A GoldenGate User Exits are not supported for DDL.
B Source and target objects can be different.
C Target objects can be different from source when using SOURCEDEFS in Replicat.
D It can use WILDCARDRESOLVE IMMEDIATE.