Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 11:

  You have written a Forms application that your users log in to with their database login. Which Forms component is utilized first when a user runs the application?

  A. Forms Client (applet)
  B. Forms Runtime
  C. Forms Servlet
  D. Forms Listener Servlet
  A. Forms Client (applet)

  ---

  Note: ORACLE APPLICATION SERVER FORMS SERVICES ARCHITECTURE The OracleAS Forms Services consists of three components: a Forms Client that is downloaded automatically to the end user's browser and cached, the Forms Listener Servlet, and the Forms Runtime - on the middle tier.

  Forms Client (Java Applet) When a user runs a Forms session, the Forms Client - a thin 100 percent Java Applet - dynamically downloads from the Oracle Application Server. This generic Java Applet provides the user interface for the associated Forms Runtime process on the middle tier, and handles user interaction and visual feedback such as that generated by navigating between items or checking a checkbox. The same Java applet is used for any Forms application, therefore it is downloaded only once and cached on the client and so is available for subsequent Forms applications

• Question 12:

  You are implementing a JavaBean in a form, the bean has no visible component on the form when invoked, the bean displays an input text where users enter a zip code, the bean has a single method that returns a short weather forecast for that zip code as a character value.

  How can you retrieve that value so that you can display it to the user?

  A. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_ITEM_EVENT in a When-Custom item Event trigger, and then use that value as an argument to the MESSAGE built in.
  B. Use FBEAN.REGISTER_BEAN as an argument to the MESSAGE built in to invoke the bean's method and return the value as a message displayed to the user.
  C. Use FBEAN.REGISTER_BEAN to register the bean, so that when the user enters a zip code into the bean s input text, the value is automatically displayed in the bean area item.
  D. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-item-Event trigger, and then use that value as an argument to the MESSAGE built-in.
  D. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-item-Event trigger, and then use that value as an argument to the MESSAGE built-in.

  ---

  When a user interacts with a JavaBean at run time, it usually causes an event to occur. You can use FBEAN.ENABLE_EVENT to register a listener for the event, so that when the event occurs Forms will fire the When-Custom-Item-Event trigger. In this trigger, you can code a response to the event. The :SYSTEM.CUSTOM_ITEM_EVENT and :SYSTEM.CUSTOM_EVENT_PARAMETERS variables contain the name of the event and information the bean is sending to the form.

• Question 13:

  There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item. You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item. When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

  A. Call the form level On-Error trigger from the item-level On-Error trigger.
  B. Call the item-level On-Error trigger from the form-level On-Error trigger.
  C. Change the Execution Hierarchy property for the item-level On-Error trigger.
  D. Change the Execution Hierarchy property for the form-level On-Error trigger.
  E. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.
  C. Change the Execution Hierarchy property for the item-level On-Error trigger.

  ---

  when you have a WHEN-NEW-ITEM-INSTANCE :

  if you create a trigger on item, block and form-level, then only the ITEM-Level will start. If you use the exec- hierarchy Override.

  If all trigger use After, then the FORM, BLOCK and ITEM starts in that sequence.

  If all trigger use Before, then the ITEM, BLOCK and FORM starts in that sequence.

  the execution-hierarchy on FORM-Level is ignored, because there is no higher level than FORM

• Question 14:

  You have been assigned to maintain a forms application that was designed by a developer who has left the company.

  The form uses different property classes to standardize the appearance of objects in the form. For example, all buttons should be of the same width.

  The CV_Tools canvas contains several buttons. The Print invoice button is not quite wide enough to display its complete label.

  In forms Builder, you open the Button_PC property class and change its Width property to a higher number. All the buttons become larger except the Print invoice button, which remains its original size. What could have caused this problem?

  A. The Print invoice button was copied from, rather than subclassed from, the Button_PC property class.
  B. The subclass information property for the Print invoice button is blank.
  C. The Width property of the Print invoice button is an inherited property.
  D. The Width property of the Button_PC property class is a variant property.
  E. The X Position of the print invoice button is a variant property.
  F. The X Position Property is not included in the Button_PC property
  A. The Print invoice button was copied from, rather than subclassed from, the Button_PC property class.

• Question 15:

  Identify a function of the Forms Servlet.

  A. It creates a dynamic HTML file.
  B. It starts a Forms runtime session.
  C. It manages network requests from the Forms Client.
  D. It connects to and communicates with the database server.
  E. It renders the Forms Services application display for the user.
  B. It starts a Forms runtime session.

  ---

  OracleAS Forms Services uses the Forms Listener Servlet (a Java servlet) to start, stop, and communicate with the Forms runtime process. The Forms runtime is what executes the code contained in a particular Forms application. The Forms Listener Servlet manages the creation of a Forms runtime process for each client and manages the network communications between the client and its associated Forms runtime process. The Forms Listener Servlet replaces the Forms Listener provided in previous releases of Oracle Forms.

  Reference: Oracle Application Server Forms Services Deployment Guide, Forms Listener Servlet

• Question 16:

  An LOV must be displayed several times in your form; therefore, good performance when displaying LOV is essential. In a When-New-Form-instance trigger, you want to save the ID of the LOV in a global variable so that you can use it in any code to display the LOV.

  Which built-in would you use to get the ID of the LOV?

  A. SHOW_LOV
  B. FIND_LOV
  C. GET_ITEM_PROPERTY
  D. GET_LOV_PROPERTY
  E. GET_APPLICATION_PROPERTY
  B. FIND_LOV

  ---

  Referencing Objects by Internal ID Finding the object ID:

  lov_id := FIND_LOV('my_lov')

• Question 17:

  In the Orders form, users often have a need to return to the first record. Because there are many employee records, it may take a long time for them to scroll up to the first record, so you create a button with the label First Record.

  When users click the first Record button, you want to display your own custom message instead of the system message "FRM-40100: At first record."

  The system message should be displayed in other cases when users attempt to scroll above the first record.

  You code the following When-Button-Pressed trigger:

  :SYSTEM.mesage_level := '5'

  UP;

  WHILE FORM_SUCCESS LOOP

  UP;

  END LOOP;

  MESSAGE ('This is the first Order');

  The button works perfectly to return to the first record and display your custom message instead of the system message. However, users report that as they continue to use the form after clicking the button, no longer see other helpful

  messages. For example, the message "FRM 40102:

  Record must be entered or deleted first" no longer appears when they attempt to scroll past the last record.

  How can you resolve this Issue so that all system messages continue to be displayed after the trigger code runs?

  A. instead of setting the system message level to 5 in the code, set it to 50.
  B. instead of setting the system message level to 5 in the code, set it to 25.
  C. Add the line of code just before the end of the loop to reset the system message level.
  D. Add a line of code just after the end of the loop to reset the system message level.
  E. Instead of setting the system message level in the When-Button-Pressed trigger, use an On- Error trigger to customize the message.
  F. Set the system message level in a When-New-Form-Instance trigger, so that all system messages appear except when in the scope of the trigger.
  F. Set the system message level in a When-New-Form-Instance trigger, so that all system messages appear except when in the scope of the trigger.

  ---

  Incorrect answers:

  A, B: changing the system message level would not help.

  C, D: The line would have to be added after the line MESSAGE ('This is the first Order'); in order to work.

• Question 18:

  You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.

  Which canvas types would be most appropriate in this scenario?

  A. content canvas in a window with a horizontal scroll bar
  B. content canvas and multiple tab canvases
  C. content canvas and a tab canvas with multiple tab pages
  D. content canvas and a stacked canvas with a horizontal scroll bar
  E. multiple content canvases
  C. content canvas and a tab canvas with multiple tab pages

  ---

  After an entity is divided into groups, if all groups cannot be displayed simultaneously, it becomes necessary for two or more regions to be displayed in the exact same space, one at a time, using a Tab control. The user can jump to a specific

  region by selecting a tab or by progressing continuously through all fields of all Tab regions. A set of fields, minimally the primary key fields, should remain visible so the user can maintain context at all times. There, "frozen" fields must be

  placed inside the Tab control on the left side.

  When best to use Tab regions:

  *

  When the user must see all fields of a record in a single window, but they do not need to see them all simultaneously.

  *

  When entire regions need to be hidden from a user due to security restrictions, the current state of data, or other product installations.

• Question 19:

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

  ---

  E: Save and compile the library.

  G: select the Attached Libraries node and click Create.

  In the Attach Library dialog box, click Browse to navigate to the saved library and open it, then answer Yes to the alert that asks if you want to remove the path.

  H: Modify the to simply call the procedure from the attached library:

• Question 20:

  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?

  A. The code should be in Pre_insert trigger instead
  B. The code should be in a database trigger instead
  C. You should change the code to select the sequence number from SUMMIT.dual instead.
  D. You should create the sequence in the database, because the runtime error is an indication that is does not exist.
  E. You should assign a temporary value to the Order_Id item before saving the form.
  E. You should assign a temporary value to the Order_Id item before saving the form.