Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z0-151 Exam Practice Test

View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

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?

Which statement is always true about a visual indicator that a text item has a list of values associated with it?

View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.
What is the probable cause of this error?

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?

Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.
In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.
Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?

You have written a When-Validate-Item trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?

Which type of variable must be declared before it is used in a trigger?

View the Exhibit.

The DBA has added a 30-character Cust_Middle_Name field to the Customers table and wants you to add it to the Customers form. It should be on the same line as the as the first and last names, which are on the Name tab page of the Tab_Customer canvas that appears in the Layout Editor as shown in the Exhibit. The Tab_Customer tabbed canvas is displayed on the Customer_CV content canvas as shown in the Exhibit.
What must you do to accommodate the additional label and text item and to display the middle name?