Oracle Forms Build Internet Applications Set 1

You colleague created a list item that will be populated at run time by the JOBS Record Group.
JOBS is populated from the EMP table using one or more of the following three columns:
- SAL column, whose data type is number
- TITLE column, whose data type is varchar2
- JOB column, whose data type is varchar2
Assuming that any variables used are properly declared, which built-ins can you to create JOBS?

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 credit ratings can be recorded. To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. With the items node of the Customers block selected in the Object Navigator, you click Create. You then open the Property Palette for the new item and set properties as follows: Name: RATING Item Type: Radio Group Data Type: Number Column Name: Rating Canvas: CUSTOMER_CV You open the CUSTOMER_CV canvas in the Layout Editor, but the Rating item does not appear.
How can you get the Rating item to appear on the canvas?

The Orders form is required to initialize differently for different users.
A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If the user has the STORE_CLERK role enabled, certain buttons are disabled and
the focus is sent to the Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. The buttons are set by a form-level procedure
(SET_BUTTONS).
The functionality is achieved with this code:
If get_role_name(USER) = 'STORE_CLERK' THEN
set_buttons('STORE_CLERK');
GO_ITEM(ORDERS.Customer_id');
ELSE
set_buttons(ADMIN_MGR');
GO_ITEM('ORDERS.Date_Ordered');
END IF;
What is the best trigger to execute this code?

In the Bonus.fmb module, you have created a Tab canvas and a Content canvas. The form has only one window. You want to reduce the size of the window so that it will fit exactly around the Tab canvas. You are in
the Layout Editor.
How do you resize the window?

There is a requirement to modify the default functionality of the [Commit] key.
To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit if necessary.
Which trigger code will achieve this?

In the Human Resourced form, you created an LOV based on a record group. The record group query selects the job title and job ID from the JOBS table, which contains the following records:
JOB_TITLE JOB_ID
- -------------
Accountant FI_ACCOUNT
Accounting Manager AC_MGR
Administration Assistant AD_ASST
President AD_PRES
Programmer IT_PROG
Public Accountant AC_ACCOUNT
Purchasing Clerk PU_CLERK
Purchasing Manager PU_MAN
Sales Manager SA_MAN
Sales Representative SA_REP
The Job_ID value is returned to the Employees.Job_Id item in the form. You attach the LOV to the Job_ID item
and set its Validate from List property to yes,
You run the form to test it. You enter "Pro" (without the quotes) into the Job_ID item.
What is the behavior when you press the Tab key?

The validation unit for the Orders form is set to Item. This master-detail form contains an Order block and a multirecord Order Items block.
Why might you want to create a When-Validate-Record trigger on the Orders block in this form?

The Products.fmb module has one content canvas, which displays information about products sold by your company. You increase the canvas display area by creating an overlay canvas that enables image of selected
products to be displayed on request.
How do you position the overlay canvas on the content canvas?

What happens when you click Run Form Debug in Forms Builder?

In a multiform application, one form must invoke another. The form modules are called Customers and Orders internally, but the compiled files are saved as CUST.FMX and ORD.FMX, respectively.
There is a button in the Customers form with a When-Button-Pressed trigger to invoke the Orders form.
There is a requirement that only one Orders form can be running at a time, so the trigger must check to see if the form is already open. If it is open, the focus must be sent to it. If it is not open, it has to be opened.
Which of these trigger codes will achieve the required functionality?