Oracle 1Z0-448 Free Practice Questions

Q1. Which product is included in ODI web-based components?(Choose the best answer.) 

A. Oracle BPEL Process Manager 

B. Oracle GoldenGate 

C. ODI Console 

D. Oracle WebLogic Server 

View Answer

Q2. You want tooverride the code generated by ODI and provide a custom SQL statementas the source of a Mapping. How must you proceed?(Choose the best answer.) 

A. Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfield. 

D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

View Answer

Q3. Identify two constraints that can be used to ensure uniqueness in ODI.(Choose two.) 

A. conditions 

B. foreign keys 

C. primary keys 

D. alternate keys 

E. not null 

View Answer

Q4. 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 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. 

B. 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. 

C. You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment. 

D. 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. 

View Answer

Q5. You need totroubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tableswhile the Mapping is being executed. How must you proceed?(Choose the best answer.) 

A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables. 

B. Modifya Knowledge Module to dump the Staging tables’ data into log files for review. 

C. Use variables in a Package to query the Staging tablesand evaluate the variable values. 

D. Reverse engineer the Staging tables in a Modeland review the data contained in it. 

View Answer

Q6. Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)?(Choose two.) 

A. It enables developers to execute most ODI operations through a Java program. 

B. It can be used to embed ODI processes into another product. 

C. It is used to load data between Teradata and Oracle. 

D. It must be used by ETL developers to develop ODI processes. 

View Answer

Q7. You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error. 

Why did this happen?(Choose the best answer.) 

A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries. 

B. It is not possible to enforce constraints on any technology. 

C. It is only possible to forward-engineer it to the flat file definition. 

D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file. 

View Answer

Q8. Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. 

How can you achieve this?(Choose the best answer.) 

A. The project must be explicitly mapped within an ODI mapping. 

B. A customize knowledge module is needed. 

C. An ODI procedure must be associated with it. 

D. It can be defined for every technology listed in the topology. 

View Answer

Q9. A Mapping that uses CDC does not load any source data and you want to check theSNP_CDC_SETtableto find out the current window ID. 

In which database schema must you look to find this table?(Choose the best answer.) 

A. the schema hosting the Work repository 

B. the schema hosting theWork schema of the default schema defined for your source data server 

C. the schema hosting the Staging Area 

D. SYS 

View Answer

Q10. You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas?(Choose the best answer.) 

A. Create one Logical Schema per Physical Schema. 

B. Create one Logical Schema per Physical Schema that stores the same type of data. 

C. Create one Logical Schema per Data Server. 

D. Create one Logical Schema per Context. 

View Answer

Q11. Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario’s schedule?(Choose the best answer.) 

A. Regenerate the existing scenario. 

B. Nothing, the existing scenario will automaticallybe updated. 

C. Generate a new scenario and create a new schedule. 

D. Generate a new scenario and attach the previous scenario’s schedule to it. 

View Answer

Q12. Which two objects can be dragged to a Mapping?(Choose two.) 

A. Variables 

B. Datastores 

C. Knowledge Modules D. Reusable Mappings 

View Answer

Q13. You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI. 

What must you do to accomplish this?(Choose the best answer.) 

A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers. 

B. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected. 

C. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI. 

D. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers. 

View Answer

Q14. You have to loop through a Mapping step three times in a package by using variables. Identify thecorrect variable data type to create the loop. (Choose the best answer.) 

A. numeric 

B. alphanumeric 

C. date 

D. text 

View Answer

Q15. Which tables created by ODI contain error records?(Choose the best answer.) 

A. ERR$ 

B. ERROR$ 

C. ODI_ERR$ 

D. E$ 

View Answer