Pass4sure offers free demo for 1z0-482 exam. "Oracle Data Integrator 11g Essentials", also known as 1z0-482 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0-482 exam, will help you answer those questions. The 1z0-482 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0-482 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-482 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q1. Identify the operation that ensures that referential integrity is maintained while loading changes detected by the ODI CDC framework.
A. Unlock Subscriber
B. Extend Window
C. Lock Subscriber
D. Purge Journal
Q2. In an ODI interface, is it mandatory to use a join to describe a lookup?
A. Yes,there are not many other graphical Objects to describe a lookup.
B. Yes, it is not possible to set anything other than a join in an ODI Interface.
C. No, there is a graphical object dedicated to set a lookup in the source area of an interface.
D. No, you can use variables in ODI to declare lookups.
Q3. A. 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.
B. Yes, it is possible to declare it but only if it is a standard SQL datatype.
C. Yes, it is possible but in any case, you need to forward-engineer the datatype via the JDBC driver.
D. No, datatypes are assigned by default as string variables.
Q4. You have to load three tables A, B, and C in parallel, wait for them to be loaded, and then
load a fourth table D. Which steps do you have to go through in order to do this?
A. Generate three scenarios to load A, B, and C, add them to a Package, set their Synchronization mode to Asynchronous, use an OdiWaitForChildSession step before adding an Interface to load D
B. Generate three scenarios to load A, B, and C, add them to a package, set their Synchronization mode to Synchronous, use an OdiWaitForChildSession step before adding an interface to load D
C. Add three Interfaces to load A, B, and C to a package, use an OdiWaitForChildSession step before adding another Interface to load D
D. Generate three scenarios to load A, B, and C, add them to a package, use an OdiWaitForChildSession step before adding an Interface to load D
Q5. When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM?
A. No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues.
B. No, it is not possible to enforce constraints on any technology.
C. Yes, it is possible also to forward-engineer it to the flat file definition.
D. Yes, but you have to save it as a fixed file.
Q6. Identify two operations that can be achieved using the ODI SDK.
A. Create users
B. Create interfaces
C. Create Master and Work repositories
D. Create security profiles
Q7. Prior to executing an interface or mapping in ODI, do you have to deploy the generated code manually in a source or target server?
A. Yes, you have to copy all the procedures generated into the development, test, and production servers.
B. No, ODI prepares a package for the development environment.
C. Yes, you have to compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.
D. No, ODI Agent coordinates the execution of the commands prepared for the job, and executes them on the correct server.
Q8. In an ODI interface, can source tables be declared as not joined?
A. Yes, ODI generates the code calculating a sample of the data, profiling it, and deciding automatically if a join exists.
B. Yes, it is possible to create an ODI procedure to declare joins for the source tables.
C. No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly.
D. No, by default, every added data store in the source declaration of an interface is joined with an inner join.
Q9. Where can users edit scenarios in ODI?
A. Designer Navigator
B. Operator Navigator
C. Command line
D. Nowhere, scenarios cannot be edited
Q10. Select the correct statement. When running an interface in ODI, is it possible to see a simu- lation of the code?
A. No, that is a current limitation in ODI.
B. No, but it is possible to query the metadata repository in order to see the generated code.
C. Yes, but it is only possible to see a code simulation on ODI Console.
D. Yes, before executing the interface, it is possible to set a flag to request the code simulation.