Oracle Fusion Middleware 11g: Build Applications with Oracle Forms v7.0 (1z0-151)

Page:    1 / 6   
Total 99 questions

You have been assigned to maintain a Forms application that was designed by a developer who has left the company.
The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.
What could have caused this problem?

  • A. The buttons inherit their properties from the same property class.
  • B. The buttons were created by dragging them from an object group.
  • C. The buttons were created by using a Smart Class.
  • D. All other buttons were subclassed from the first button.
  • E. All other buttons were copied from the first button.
  • F. The first button was subclassed from another button.
  • G. The first button was copied from another button.

Answer : D

Explanation: D (not F): With subclassing you can make an exact copy, and then alter the properties of some objects if desired. If you change the parent class, the changes also apply to the properties of thesubclassed object that you have not altered. However, any properties that you override remain overridden. This provides a powerful object inheritance model.

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?


Answer : B

Explanation: Referencing Objects by Internal ID
Finding the object ID:
lov_id := FIND_LOV('my_lov')

Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by
Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

  • A. Add a blank line to the list item when you define the static values.
  • B. Set Mapping of other Values for the Credit_Rating Item to NULL.
  • C. Set the Required property of the Credit_Rating item to No.
  • D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.
  • E. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.

Answer : A

You have coded the following When Button Pressed trigger:
MESSAGE ('Query executed on block');
MESSAGE ('click next to navigate the next record');
When the user clicks the button, how is the message "Query executed on block" displayed?

  • A. as a system message on the status line
  • B. as a system message in a system alert
  • C. as a system message in an application alert
  • D. as an application message on the status line
  • E. as an application message in a system alert
  • F. as an application message in an application alert

Answer : E

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.

Answer : D

Explanation: 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.

The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

  • A. True
  • B. False

Answer : B

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?

  • A. Ensure that required is set to No for the list item so that a blank line appears in the list.
  • B. Set the Mapping of Other Values property for the list item.
  • C. Set the Default Value property for the list item.
  • D. Set the Query Allowed Property for the list Item.
  • E. Users must re-enter the records for those customers that cannot be accessed.

Answer : B

Explanation: The important property is the "mapping of other values." This property tells
Oracle Forms how to handle values that are not expected.

Which three are valid ways to populate a display item?

  • A. initial Value property
  • B. User input
  • C. When-Button-Pressed trigger
  • D. Calculation
  • E. Executing a query

Answer : A,C,D

C: You can use the attachable PL/SQL libraries to implement a flexible message function formessages that are displayed programmatically by the built-in routines MESSAGE orCHANGE_ALERT_MESSAGE, or by assigning a message to a display item from a triggeror procedure.

D: Creating Calculated Items -
Change the Item Type to Display Item.
Set the Calculation Mode property to Formula.
Set the Formula property to the required formula.

Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
You also have a button in the Control block labeled Query Orders with a When-Button
Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?

  • A. Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-New-Form-instance trigger.
  • B. Change the last line of the When-Button-Pressed code to: DO_KEY ('EXECUTE_QUERY');
  • C. Delete the Key-Exqry trigger and put its code in an On-Select trigger.
  • D. Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.

Answer : B


Note: EXECUTE_QUERY procedure -
Clears the current block, opens a query, and fetches anumber of selected records. If there are changes tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE-QUERYprocessing

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.
Which WebUtil package would you use to implement this requirement?


Answer : C

Note: Performing OLE Automation on the Client
You can use any OLE2 package on the client by prefixing it with CLIENT_. You can see the list of the OLE2 package procedures and functions in the Forms Builder ObjectNavigator under the Built-in Packages node.
Note 2: With WebUtil, you can do the following on the clientmachine: open a file dialog box, read and write image or text files, execute operating system commands, perform OLE automation, and obtain information about the client machine

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?

  • A. increase the Width property of the Customer_CV canvas only.
  • B. increase the Width property of the Tab_Customer canvas only.
  • C. increase the Width properties of only the Customer_CV canvas and the Tab_Customer canvas.
  • D. increase the Width properties of the Customer_CV canvas, the Tab_Customer canvas, and the name tab page.

Answer : C

You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties.
You want users to be able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.
However, when you test the form, you find that you are unable to close either window.
What must you do to provide this functionality?

  • A. Change the second window to a modal window.
  • B. Code a When-Window-Closed trigger for each window.
  • C. Set Close Allowed to Yes for both windows.
  • D. Set Hide on Exit to Yes for both windows.

Answer : B

View the Exhibit.

What four facts can you determine by examining the Object Navigator?

  • A. The Orders block is a detail block.
  • B. The Order_Items block is a detail block.
  • C. An order can be deleted only if it has no order items.
  • D. If an order is deleted, all of its order items are deleted.
  • E. You cannot delete order items without deleting the order.
  • F. You can delete an order without deleting its order items.
  • G. The Orders block is a master block.
  • H. The Order_Items block is a master block.
  • I. If you delete an order item, all of its associated inventory items are deleted.
  • J. The inventories block is a master block.

Answer : B,C,G,H

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

  • A. Change the initial Value property to Good.
  • B. Change the Check Box Mapping of Other Values property to Not Allowed.
  • C. Change the initial Value property to Good and the Value When Unchecked property to Null.
  • D. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
  • E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
  • F. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.

Answer : F

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. You receive a compilation error.
  • B. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
  • C. The form runs, but as soon as it appears, you receive a runtime error.
  • D. The form runs, but as soon as you perform any navigation, a runtime error occurs.
  • E. The form runs with no problem.

Answer : C

Page:    1 / 6   
Total 99 questions