Online Access Free 1z1-447 Practice Test

Which statement correctly explains when you would use ASSUMETARGETDEFS?

• A.The target tables are already created.
• B.You have specified wildcards in either the TABLE or MAP parameters
• C.Only the fields in the target tables are mapped.
• D.The source and target tables have identical data structure.

Which three are types of encryption supported by OGG?

• A.Trial file encryption
• B.Parameter file encryption
• C.Password
• D.Message encryption

What is the function of the GoldenGate JAgent?

• A.It reads the database transaction logs.
• B.It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent.
• C.It performs connections via JDBC to run the Veridata comparisons.
• D.It integrates GoldenGate with Oracle Data Integrator.

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

• A.Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• B.Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• C.any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
• D.Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

• A.The Extract will revert to single-row fetch mode for all tables.
• B.The Extract will perform poorly due to paging unless LOBMEMORY is increased.
• C.The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
• D.The Extract will abend unless LOBMEMORY is increased.