1Z0-447 Oracle Exam Questions and Free Practice Test

Question 7

How can you tell if GoldenGate has been configured for batch processing?

A. TheSPECIALRUNparameter is in the Replicat parameter file.

B. Replicat is started with theINITIALLOADtask.

C. There is a dedicated GoldenGate process calledSPECIALRUN.

D. TheSPECIALRUNparameter is in theGLOBALSparameter file.

Correct Answer:B

Question 8

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A. The target tables are already created.

B. Only the fields in the target tables are mapped.

C. The source and target tables have identical data structure.

D. You have specified wildcards in either the TABLE or MAP parameters

Correct Answer:C

Question 9

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

A. Oracle Gateway software configured for that particular database platform

B. JDBC drivers into the GoldenGate home directory

C. Microsoft Visual C++ 2010 SP1 Redistributable Package

D. Nothing, configure GoldenGate Jagent for that particular database platform.

Correct Answer:C

Question 10

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to–database utility. How should you configure GoldenGate in order to accomplish this?

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.

Correct Answer:C

Question 11

You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?

A. You can configure integrated Replicat with two parallel apply servers.

B. You can configure integrated Replicat with two parallel child servers.

C. You can configure integrated Replicat with theSPECIALRUNparameter.

D. You can configure integrated Replicat withASSUMETARGETDEFSandSPECIALRUNparameters.

Correct Answer:A

Question 12

By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

Correct Answer:E

START 1Z0-447 EXAM