Online Access Free 1z1-151 Exam Questions

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.
After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:
FRM-10142: The HTTP Listener is not running on <host> at port 9001.
Please start the listener or check your runtime preferences.
What is one action that you can take to resolve this error?

• A.Start WebCache.
• B.Start the Web Logic Administration server.
• C.Start the Oracle HTTP server.
• D.Start the WLS_FORMS managed server.
• E.Change the serverURL parameter in formsweb.cfg

You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?

• A.restricted and unrestricted built-ins only
• B.PL/SQL statement-, and any built-ins
• C.unrestricted built-ins only
• D.PL/SQL statements and unrestricted built-ins only

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

• A.Only A and B are true.
• B.Only B and C are true.
• C.Database transactions are always continued across forms.
• D.None of the statements above are true.
• E.A calling form must pass data to a called form.
• F.Code is always shared among forms.
• G.A global record group is always created.
• H.Only C and D are true.

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 = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;
• B.IF ERROR_CODE = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• C.IF ERROR-CODE = 20101 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;

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.Attach the library to the orders form.
• B.Save the library.
• C.Delete the BEGIN and END statements (lines 4 and 7).
• D.Change line 5 to:
  filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';.
• E.Change product_id to an in parameter and filename to an OUT parameter.
• F.Generate the a .plx file.
• G.insert the RELEASE keyword between lines 1 and 2.
• H.Change the way the program unit is called in the Orders form.