Oracle Forms Build Internet Applications Set 1

The DBA has added STATE column to the CUSTOMERS table and has asked you to add a corresponding
State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation.
Most customers are located in five southeastern states, although on very rare occasions there will be
customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director for those customers outside the region.
Which style of list item will you create for the State item?

While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following
code:
CALL_FORM('orders');
There is a requirement to navigate back to the Customers form after the order details have also been updated.
This will be achieved through a form-level Key-Exit trigger in the Orders form.
Which code should be used?

Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that data entry clerks can populate the RATING column.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item.
With the Customers block selected in the Layout Editor, you use the radio button to create three radio buttons on the canvas. You then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio
buttons. You set the name of the radio group to RATING, its Data Type to Number, and its Database column to Rating.
You run the form to test it. When you execute a query, however, no records are returned, although there are many customer records in the database.
What can you do to make the query return the records?

You are editing the INVENTORY tab canvas. You set the Tab Attachment Edge property to RIGHT.
You also change the ordering of INVENTORY tab pages in the Object Navigator. The Direction property has not been customized.
What influence will this have on the display of tab pages at run time?

In the Product.fmb module, data block items are displayed on two content canvases. You define a set of icon buttons that users must have access to at all times.

Which canvases type is appropriate to display the buttons?

To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from the triggers or menu items.
You want the message "Credit limit exceeded" to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria.
Which code do you use?

How can you programmatically determine which button a user pressed to respond to an alert?

There is a requirement in the Orders form to direct the focus depending on the value in the Sales Rep Id text item. The design team has not yet decided on the exact details, but you propose the following style of code: IF :ORDERS.Sales_Rep_Id = ... THEN --value to be decided later GO_ITEM(...); --item to be decided later ELSE GO_ITEM(...); --item to be decided later END IF; A colleague suggest that the code could be called from the triggers listed below. In fact, not all these triggers can execute the code. Which triggers can call the code? (Choose all that apply)

The REGIONS non-query Record Group has two char columns.
Which built-in can you use to replace any existing rows in REGIONS with the results of a query?

You are a developer in the IT department of a municipal utility. You have been tasked with integrating two applications that are already in production.
The first application is a customer management system. Its main form is the Customers form, in which utility clerks enter and update customer information.
The second application is a GIS application. One of its forms, the Address form, enables clerks to enter an address, click a button, and have the address verified and property formatted according to postal standards.
You need to add a button to the Customers form that will pass the customer address to the Address form and receive the properly formatted address back. A variable of the user-defined type Addr_Typ will contain the address information to be passed back and forth between the two users.
Which method of sharing data will you use?