Oracle
1Z0-151 · Question #49
1Z0-151 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Question
You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is: 1. PROCEDURE get_image IS 2. Product_image_id ITEM := FIND_ITEM ('control.product_image'); 3. Filename VARCHAR2(250); 4. BEGIN 5. Filename := TO_CHAR(:order_items.product_id) | | '.jpg'; 6. READ_IMAGE_FILE (filename, 'jpeg', product_image_id); 7. END; Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form. What three things must you do to compile the PL/SQL library and to use the code in the Orders form?
Options
- AChange line 5 to:
- Binsert the RELEASE keyword between lines 1 and 2.
- CDelete the BEGIN and END statements (lines 4 and 7).
- DChange product_id to an in parameter and filename to an OUT parameter.
- ESave the library.
- FGenerate the a .plx file.
- GAttach the library to the orders form.
- HChange the way the program unit is called in the Orders form.
Unlock 1Z0-151 to see the answer
You've previewed enough free 1Z0-151 questions. Unlock 1Z0-151 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.