Oracle 1Z0-448 Free Practice Questions

Q1. You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?(Choose the best answer.) 

A. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task. 

B. Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source. 

C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep. 

D. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source. 

View Answer

Q2. You are designing a Mapping. How are target and source tables defined?(Choose the best answer.) 

A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database. 

B. Their definition is imported with a reverse-engineering process directly from databases and other sources. 

C. Forevery load the definition of the tables used, their columns and constraints must be manually built. 

D. An external engine must be run to describe what metadata is needed for a Mapping. 

View Answer

Q3. How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server?(Choose the best answer.) 

A. from the source database into flat files that are then loaded into the target database 

B. directly from the source database to the target database 

C. from the source database onto the server running the Agent and then into the target database 

D. from the source database into the machine running ODI Studio and then into the target database 

View Answer

Q4. You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer) 

A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design. 

B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design. 

C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design. 

D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design. 

View Answer

Q5. You must monitor and managea co-located stand-alone agent,OracleDIAgent1, by using the ODI plug-in for Enterprise Manager CloudControl. Which is the correct command to start this agent on Linux?(Choose the best answer.) 

A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910 

B. ./agent.sh –NAME=OracleDIAgent1 

C. ./startComponent.sh OracleDIAgent1 

D. ./startComponent.sh OracleDIAgent1 –PORT=20910 

View Answer

Q6. Which two statements are true about big data support in ODI?(Choose two.) 

A. ODI uses its own transformation engine to process data in a Hadoop cluster. 

B. ODI performs data transformations inside a Hadoop cluster. 

C. ODI must perform data transformations outside Hadoop in an Oracle database. 

D. ODI allows moving data in and out of a Hadoop cluster. 

View Answer

Q7. You want to modify the code generated by a failed Task and restart the session. How must you proceed?(Choose the best answer.) 

A. Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it. 

B. It is not possible to modify the code once it has been generated. 

C. Open the Step in Operator, edit the code, and save it. 

D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it. 

View Answer

Q8. You need to create a Model that works with multiple underlying technologies. How must you proceed?(Choose the best answer.) 

A. This works only for Oracle and Informix. 

B. This works only for Oracle and MySQL. 

C. Create a new generic technology to support it. 

D. Use the out-ofthe box Generic SQL technology. 

View Answer

Q9. How can you define the order in which target data stores are loaded in a Mapping?(Choose the best answer.) 

A. ODI automatically computes the load order based on the order on which the data stores were added to the Mapping. 

B. You can use the Target Order field. 

C. You can use the Target Load Order field. 

D. You can use the Load Order field. 

View Answer

Q10. You need to create a package that automatically sends an alert to users in case the third step fails. 

Which option represents the steps to accomplish this?(Choose the best answer.) 

A. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow. 

B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow. 

C. Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow. 

D. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow. 

View Answer

Q11. Which is the correct statement about the contents of Master repositories?(Choose the best answer.) 

A. They contain data model and security information. 

B. They contain security and topology information. 

C. They contain project and topology information. 

D. They contain project and security information. 

View Answer

Q12. You are working on notifications in a package and you must send an email containing an error message incase a Package step fails. 

WhichodiRefmethod do you use to access the error message?(Choose the best answer.) 

A. odiRef.getSession() 

B. odiRef.getInfo() 

C. odiRef.getPrevStepLog() 

D. odiRef.getStep() 

View Answer

Q13. You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day. 

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping?(Choose the best answer.) 

A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping. 

B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping. 

C. Duplicate the source data store for each Mapping. 

D. Create two distinct subscribers for each Mapping. 

View Answer

Q14. Identify three capabilities of load plans. (Choose three.) 

A. restart from failed tasks 

B. exception handling 

C. native support for parallelism 

D. support for Open Tools 

E. restart of an agent 

View Answer

Q15. How do you reuse a configuration ofOdiSendMailacross multiple packages?(Choose the best answer.) 

A. Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes. 

B. Add anOdiSendMailstep to a knowledge module. 

C. Duplicate theOdiSendMail stepinto multiple packages. 

D. Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages. 

View Answer