Oracle 1z0-482 問題集

質問 1：
Select four correct scenarios where EDQ parsing is beneficial.
A. Phone numbers are sometimes embedded in the customer name and address.
B. The data contains product descriptions in the string field and you need to extract the size and weight of each product.
C. There are separate attributes for Titles, Forenames, and Family names, but the values are not always in the right fields.
D. Addresses are contained in a single string field and are difficult to verify.
E. Names are well-structured, but the Gender field is often missing.
正解：A,B,C,D

質問 2：
In Topology, can a query be defined to retrieve native database sequences?
A. No, the query for native sequences is defined in ODI Data Models, under ODJ Studio Designer.
B. Yes, in the technology details in the Topology submodule, there is a tab that defines queries for specific database elements.
C. No, only the timestamp definition can be set in Topology.
D. Yes, but you need to specify an option in the knowledge modules of the mapping using sequences.
正解：B

質問 3：
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. Yes, but you need to use as mandatory Oracle BPEL in order to process the job invocation.
C. Yes, both standalone and JEE agent support web services.
D. No, it is only possible to run jobs internally or via command line.
正解：C

質問 4：
You are loading a file into a database but the file name is unknown at design time and will have to be passed dynamically to a Package at run time; how do you achieve this?
A. Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Set Variable step
B. Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Declare Variable step
C. Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Set Variable step
D. Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Declare Variable step
正解：D

質問 5：
When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM?
A. Yes, but you have to save it as a fixed file.
B. Yes, it is possible also to forward-engineer it to the flat file definition.
C. No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues.
D. No, it is not possible to enforce constraints on any technology.
正解：C