Online Access Free 1z0-1094-22 Practice Test

Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

• A.database link
• B.listing port of the oracle listener
• C.name of the Oracle Instance (SID) or service
• D.list of all schemas
• E.network name or IP address of the machine hosting the Oracle Database

You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

• A.Flat file data has to have a header row in order to join with Oracle database table in a single mapping
• B.Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load.
• C.It is not possible to join data from different source connection types in a Single mapping
• D.It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.
• E.It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

• A.Both Physical and Logical Migration is supported.
• B.Logical Migration only
• C.Physical Migration only
• D.ZDM does not support Inflight Upgrade.

You encounter error ORA-00245 while performing Zero Downtime Migration of an Oracle RAC database. What might be the reason for this?

• A.Port 1521 is open.
• B.SNAPSHOT CONTROL is not pointing to a shared location on all Oracle RAC instances.
• C.TDE Wallet is configured.
• D.The RAC instances are running in Archivelog mode.

Which parameter can be used to export a subset of data using Data Pump?

• A.SUBSET_AS_TABLES
• B.MATERIALIZED_VIEWS
• C.TABLES_AS_VIEWS
• D.VIEWS_AS_TABLES