You created a LOV based upon a three-column Record Group called CUST, which was created at design time.
View the Exhibit and examine the structure of the CUST Record Group.
At run time, the user sometimes requires the LOV to be populated from the PROD Record
Group.
Which two built-ins will enable you to create the PROD Record Group and repopulate the
LOV? (Choose two.)
Answer : C,E
What are two ways that you can assign a value to an item on a form from within the code of a menu item? (Choose two).
Answer : A,E
Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).
Answer : B,C
While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.
After the LOV is created, you realize that you should have assigned the LOV to the
Sales_Rep_Id item instead. What can you do to make this change?
Answer : B
View the Exhibit.
You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records.
The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records. What can you do to improve performance without losing the fast initial response?
Answer : D
View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345.
To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?
Answer : D
You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table item. What is a possible cause for this problem?
Answer : A
The user must be able to invoke a list of values for valid sales representatives in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep Id field.
The text item has these properties set:
- Required: Yes
- List of Values: SALES_REP_LOV
- Validate from List: No
The button has these properties set:
- Keyboard Navigable: Yes
- Mouse Navigate: Yes
- Iconic: Yes
- Icon Filename: list.ico
An appropriate LOV has been created (called SALES_REP_LOV) and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults.
You write a When-Button-Pressed trigger at the item level with this code:
LIST_VALUES;
To test the form, you attempt to enter a new record. What is the run-time behavior of the form?
Answer : D
An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.
One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:
GO_BLOCK('Customers');
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
You do not want trigger processing to continue if there is any type of error in navigating to the Customers block. How should you modify the code?
A. GO_BLOCK('Customers');
if FORM_SUCCESS then
EXECUTE_QUERY;
end if;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
B. GO_BLOCK('Customers');
if not FORM_FAILURE then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
C. GO_BLOCK('Customers');
if not FORM_SUCCESS then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Items');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY -
D. GO_BLOCK('Customers');
if FORM_FATAL then
raise FORM_TRIGGER_FAILURE;
end if;
EXECUTE_QUERY;
GO_BLOCK('Orders');
EXECUTE_QUERY;
GO_BLOCK ('Items');
EXECUTE_QUERY -
Answer : C Topic 1, B B
In your Employee.fmb module you have an EMP block, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this? (Choose two.)
Answer : B,F
Consider the following scenario:
Answer : E
The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other errors:
IF message_code = 40100 THEN -
MESSAGE('You are already at the first record');
ELSE -
MESSAGE(message_type || '-' ||
to_char(message_code) || ': ' || message_text);
END IF;
When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.
What corrections can you make so that the code functions properly?
Answer : A
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. You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit rating from a value to an undetermined rating. How can you implement this?
Answer : C
The Orders form is a master-detail form in which ORDERS is a single-record master block and ORDER_ITEMS is a multirecord detail block.
During testing of the Orders form, users have complained about the behavior of Enter-
Query mode.
In the form they are testing, they are unable to navigate out of the current block while they are in Enter-Query mode. However, they would like to be able to carry out the following procedure:
1. Press [Enter Query] while in the master block.
2. Enter some search criteria.
3. Navigate to the detail block.
4. Enter more search criteria (while the form is still in Enter-Query mode).
5. Press [Execute Query] to have the criteria applied to both blocks at once.
How can you provide the requested functionality?
Answer : C
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 to enable product images to be displayed on request. At run time, however, the overlay canvas is never displayed; users complain that there is only a brief flash on their screen. How do you correct this problem?
Answer : A