Free Oracle 1z1-482 Exam Dumps Questions & Answers

Select the correct statement. When an ODI interface is designed, target and source tables are defined with metadata imported directly from databases and other sources.

• A.  Yes, their definition is imported with a direct reverse-engineering process.
• B.  No, an external engine must be run in order to describe what metadata is needed for an O interface.
• C.  Yes, their definition is imported with a direct reverse-engineering process, but you must manually define all the keys and constraints existing on the database.
• D.  No, for every loading, the definition of the tables used, their columns, and their constraints must be manually built.

Identify two true statements regarding the ODI web-based components.

• A.  ODI Console allows administrators to edit users' information.
• B.  Enterprise Manager Fusion Middleware Control Console provides access to ODI dataservers settings.
• C.  ODI Console provides access to Project and Interface details.
• D.  ODI sessions can be monitored in Enterprise Manager Fusion Middleware Control Console.

Is it possible to invoke an ODI job as a public web service to execute it?

• A.  No, there are only internal specific application program interfaces that you can use to run a job.
• B.  No, it is only possible to run jobs internally or via command line.
• C.  Yes, both standalone and JEE agent support web services.
• D.  Yes, but you need to use as mandatory Oracle BPEL in order to process the job invocation.

In ODI, when you add a column definition in a table, can you also use a technology-specific datatype for it?

• A.  Yes, it is possible to declare it but only if it is a standard SQL datatype.
• B.  Yes, it is possible but in any case, you need to forward-engineer the datatype via the JDBC driver.
• C.  Yes, it is possible to declare it, and if the desired datatype is not in the list available, you can also add it into a Topology datatypes definition.
• D.  No, datatypes are assigned by default as string variables.

When the data, source, and target are persistent in the same data server, in an ODI interface, do you need an LKM and an LKM to load the data on target?

• A.  No, only an IKM multi-technology is required,
• B.  Yes, an LKM multi-technology and an IKM single technology are required.
• C.  Yes, both an LKM multi technology and an IKM multi-technology are required.
• D.  No, only an IKM single technology is required.