Oracle 1z0-448 問題集

質問 1：
You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this? (Choose the best answer.)
A. You must deploy the generated code manually in a source or target server. You must then 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.
B. You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.
C. You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.
D. You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
How are the ODI repositories upgraded? (Choose the best answer.)
A. by using Opatch
B. by using the import/export utilities
C. by using ODI Studio
D. by using Upgrade Assistant
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)
A. Evaluate Variable
B. Declare Variable
C. Set Variable
D. Refresh Variable
正解：C

質問 4：
Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)
A. ODI Runtime Agent
B. ODI Colocated Standalone Agent
C. ODI JEE Agent
D. ODI Standalone Agent
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which are the two correct statements about Work repositories? (Choose two.)
A. They contain data and security information.
B. They contain project and security information.
C. They contain data models and execution information.
D. They contain data models and project information.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK.
What happens at run time when a Mapping gets executed? (Choose the best answer.)
A. Only the latest entry is processed based on theJRN_DATEfield.
B. All distinct entries are processed.
C. Only the first entry is processed based on theJRN_DATEfield.
D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)
A. OdiFileCopy
B. OdiOutFile
C. OdiFileMove
D. OdiInFile
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation? (Choose the best answer)
A. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.
B. Only ODI variables can be used to filter the target table loading.
C. It is not possible to use a specific partition.
D. An option in the Mapping can be used to declare the partition that has to be used for the loading.
正解：D
解説: (Topexam メンバーにのみ表示されます)