Oracle Exam 1Z0-448 Topic 9 Question 16 Discussion

Actual exam question for Oracle's 1Z0-448 exam

Question #: 16
Topic #: 9

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

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

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

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

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

Show Suggested Answer

Suggested Answer: B

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/procedures.htm#ODIDG408)

by Lindsey at May 07, 2022, 08:04 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-448 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!