Oracle 1z0-482 問題集

質問 1：
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

質問 2：
To declare mapping on a target column, does a developer have to manually write the required database functions?
A. Yes, ODI only allows manual insertion of information related to source-target mappings.
B. No, a developer must prepare a configuration file and associate to it a user function,
C. Yes, either the work area can be used to write the functions or a configuration file can be prepared for ODI to read.
D. No, a graphical expression editor can be used to drag and drop columns and the required function definitions.
正解：D

質問 3：
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

質問 4：
What is a relationship in a matching process?
A. It is a link between two records, created by automatic match rules and manual decisions.
B. It is matching functions that determine how well two records match each other, for a given identifier.
C. It is how many matched records exist globally.
D. A Relationship determines how many comparison results are interpreted during the matching process.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Select the correct statement. When running an interface in ODI, is it possible to see a simul-ation of the code?
A. Yes, but it is only possible to see a code simulation on ODI Console.
B. Yes, before executing the interface, it is possible to set a flag to request the code simulation.
C. No, that is a current limitation in ODI.
D. No, but it is possible to query the metadata repository in order to see the generated code.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. No, an external engine must be run in order to describe what metadata is needed for an O interface.
B. Yes, their definition is imported with a direct reverse-engineering process.
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.
正解：B