No matter your years in IT, the 1z1-151 exam demands real preparation — Lead2Passed supports newcomers and veterans alike with 90+ Q&As covering the Oracle Fusion Middleware 11g: Build Applications with Oracle Forms objectives, verified answers, and support that answers around the clock.
Oracle 1z1-151 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Fusion Middleware 11g: Build Applications with Oracle Forms |
| Exam Number: | 1Z0-151 |
| Exam Price: | USD 245 |
| Real Exam Qty: | 70-80 |
| Passing Score: | 65% |
| Exam Format: | Scenario-based, Multiple Choice |
| Available Languages: | English |
| Exam Duration: | 135 minutes |
| Related Certifications: | Oracle Certified Professional, Oracle Fusion Middleware 11g Forms Developer |
| Certificate Validity Period: | Retired, no recertification required |
| Recommended Training: | Oracle Fusion Middleware 11g: Build Applications with Oracle Forms |
| Exam Registration: | Oracle Education Pearson VUE Registration |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Computer-based testing at Pearson VUE centers (exam retired) |
| Pre Condition: | No mandatory prerequisite; strong SQL and PL/SQL knowledge recommended |
| Official Syllabus URL: | https://education.oracle.com/certification |
Oracle 1z1-151 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Menus, Reusability and Advanced Features | 10% | - WebUtil and client-server interaction - Object groups, classes and property inheritance - Create custom and pop-up menus |
| Topic 2: Triggers and Program Units | 20% | - Write and debug PL/SQL logic - Trigger types, scope and execution hierarchy - Validation and error handling - Reuse code via libraries and program units |
| Topic 3: Deployment, Testing and Maintenance | 10% | - Configuration and runtime parameters - Debug and troubleshoot runtime issues - Deploy Forms applications to Web environment |
| Topic 4: Forms Builder Environment | 10% | - Navigate and customize the development interface - Use online help and documentation - Form module objects and properties |
| Topic 5: Introduction to Oracle Forms Builder and Forms Services | 10% | - Forms Builder and Forms Services features - Fusion Middleware 11g architecture and components - Module types and runtime modes |
| Topic 6: Data Blocks and Database Interaction | 20% | - Create base and control blocks - Query data and modify block properties - Master-detail relationships - Transaction processing and commit control |
| Topic 7: Items, Canvases and Windows | 20% | - Content, stacked, tab and toolbars canvases - Define windows and navigation behavior - Layout and visual attributes - Text items, LOVs, list items, check boxes |
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Essentials: Try, Buy, Study
- Items, Canvases and Windows (20%)
- Forms Builder Environment (10%)
- Introduction to Oracle Forms Builder and Forms Services (10%)
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Sample Questions:
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?
- A. Save the library.
- B. Change the way the program unit is called in the Orders form.
- C. Attach the library to the orders form.
- D. Change product_id to an in parameter and filename to an OUT parameter.
- E. Change line 5 to:
filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';. - F. Generate the a .plx file.
- G. Delete the BEGIN and END statements (lines 4 and 7).
- H. insert the RELEASE keyword between lines 1 and 2.
Correct Answer: A,B,C 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
View the Exhibit.
What four facts can you determine by examining the Object Navigator?
- A. If an order is deleted, all of its order items are deleted.
- B. If you delete an order item, all of its associated inventory items are deleted.
- C. The Order_Items block is a master block.
- D. An order can be deleted only if it has no order items.
- E. The inventories block is a master block.
- F. The Orders block is a detail block.
- G. The Orders block is a master block.
- H. You cannot delete order items without deleting the order.
- I. You can delete an order without deleting its order items.
- J. The Order_Items block is a detail block.
Correct Answer: A,D,G,J 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
The Orders application enables the Orders form to be opened from the Customers form.
Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.
What could be the possible cause of this problem?
- A. The Orders form is opened in NO_ACTIVATE mode.
- B. The Orders form is opened in ACTIVATE mode.
- C. The Orders form is Opened in the same session as the Customers form.
- D. The trigger that opens the Orders form calls COMMIT_FORM after open form.
- E. The Orders form is opened in a different session from the Customers form.
Correct Answer: D 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?
- A. The form runs, but as soon as you perform any navigation, a runtime error occurs.
- B. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
- C. You receive a compilation error.
- D. The form runs with no problem.
- E. The form runs, but as soon as it appears, you receive a runtime error.
Correct Answer: E 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
View the Exhibit.
To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?
- A. IF ERROR-CODE = 20101 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF; - B. IF ERROR_CODE = 20101 THEN
MESSSAGE(SQLERRM);
END IF; - C. IF ERROR_CODE = 06512 THEN
MESSSAGE(DBMS_ERROR_TEXT);
END IF; - D. IF ERROR_CODE = 06512 THEN
MESSSAGE (SQLERRM);
END IF; - E. IF ERROR_CODE = 40509 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF - F. IF ERROR_CODE = 40509 THEN
MESSSAGE (SQLERRM);
END IF;
Correct Answer: B 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
Viewing page 1 out of 18 pages.
Viewing questions 1-5 out of 90 questions.
1266 Customer Reviews
