Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z0-151 Exam Practice Test
View the Exhibit.
You have integrated the WebUtil utility into the Orders form. You code a When-Button- Pressed trigger to call some WebUtil functionality, and then run the form to test it.
Everything works as it should.
You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.
What is a probable cause of this error?
You have integrated the WebUtil utility into the Orders form. You code a When-Button- Pressed trigger to call some WebUtil functionality, and then run the form to test it.
Everything works as it should.
You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.
What is a probable cause of this error?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Users do not want to see the "Working" message while a long query completes.
You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?
You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test 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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
View the Exhibit.
The orders form contains two canvases. Orders_CV displays one order and all of its order items.
Help-CV displays context-sensitive help.
When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.
How can you move the help information to the right so that the Customer_Id item is visible?
The orders form contains two canvases. Orders_CV displays one order and all of its order items.
Help-CV displays context-sensitive help.
When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.
How can you move the help information to the right so that the Customer_Id item is visible?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the
:Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the
:Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
View the Exhibit.
You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?
You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?
Correct Answer: C,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: C,D,G
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
View the Exhibit.
You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?
You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).