oracle9i forma developer:build internet applications v5.0 (1z0-141)

Page:    1 / 10   
Total 138 questions

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.)

  • A. RETRIEVE_LIST(lov_id, 'PROD');
  • B. POPULATE_LIST(lov_id, 'PROD');
  • C. SET_LOV_PROPERTY(lov_id,GROUP_NAME,'PROD');
  • D. CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT P_id, '|| ' date_sold as Date, Name as Desc '|| ' from products ' );
  • E. CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT P_id as ID, '|| ' Name as Desc, date_sold as Date '|| ' from products ' );
  • F. CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT rownum as Index, P_id as ID, '|| ' Name as Desc, date_sold as Date '|| ' from products ' );


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).

  • A. Use the COPY built-in.
  • B. Use the NAME_IN built-in.
  • C. Use the FIND_ITEM built-in.
  • D. Use the SET_ITEM_PROPERTY built-in.
  • E. Use the EXECUTE_TRIGGER built-in to call code in the form that assigns the value.


Answer : A,E

Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).

  • A. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.
  • B. FORM_TRIGGER_FAILURE does not cause an unhandled exception.
  • C. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
  • D. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.
  • E. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the PL/SQL block that contains it.
  • F. You must code an exception handler to define how you want the FORM_TRIGGER_FAILURE exception to function.


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?

  • A. Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.
  • B. Delete the value in the List of Values property for the Sales_Rep_Name item and set the List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.
  • C. Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.
  • D. Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.


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?

  • A. Set Single Record to Yes.
  • B. Set Query All Records to Yes.
  • C. Set Query Array Size to a larger number.
  • D. Set Number of Records Buffered to a larger number.
  • E. Set Number of Records Buffered to a smaller number.
  • F. Set Number of Records Displayed to a smaller number.


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?

  • A. No changes are required.
  • B. Delete the BEGIN and END keywords.
  • C. Define an EXCEPTION section to handle exceptions.
  • D. Pass the Forms variable to the package function with the format :block_name.item_name.
  • E. Define a DECLARE section to declare PL/SQL variables.


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?

  • A. The Hire Date item is a display item.
  • B. The Hire Date item has its Enabled property set to No.
  • C. The Hire Date item has its Query Allowed property set to Yes.
  • D. The Hire Date item width is not large enough to display the complete date.


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?

  • A. The form doesn't compile and therefore cannot be tested.
  • B. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.
  • C. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
  • D. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
  • E. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.


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.)

  • A. 1. Create a tab canvas in the Layout Editor. 2. For each item, associate the tab canvas by specifying the Canvas property. 3. Set the Rendered property of each item to Yes.
  • B. 1. Create a tab canvas in the Layout Editor. 2. For each item, associate the tab canvas by specifying the Canvas property. 3. For each item, associate the tab page by specifying the Tab Page property.
  • C. 1. Create a tab page in the Layout Editor. 2. Associate the content canvas with each item by specifying the Item Canvas property. 3. For each item, associate the tab page by specifying the Tab Page property. 4. Set the Visible property of each item to Yes.
  • D. 1. Create a canvas in the Object Navigator. 2. Set the Canvas Type property to Content. 3. For each item, associate the new canvas by specifying the Item Canvas property.
  • E. 1. Create a canvas in the Object Navigator. 2. Set the Canvas Type property to Tab. 3. For each item, associate the new canvas by specifying the Item Canvas property. 4. Set the Rendered property of each item to Yes.
  • F. 1. Create a canvas in the Object Navigator. 2. Set the Canvas Type property to Tab. 3. For each item, associate the new canvas by specifying the Item Canvas property. 4. For each item, associate the tab page by specifying the Tab Page property.


Answer : B,F

Consider the following scenario:

  • A. CLOSE_FORM('FormA'); GO_FORM('FormD');
  • B. CLOSE_FORM('FormA'); GO_FORM('FormC');
  • C. CLOSE_FORM('FormB'); GO_FORM('FormC');
  • D. CLOSE_FORM('FormC'); GO_FORM('FormB');
  • E. CLOSE_FORM('FormC'); GO_FORM('FormD');
  • F. CLOSE_FORM('FormD'); GO_FORM('FormA');


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?

  • A. Change all occurrences of message_code, message_type, and message_text to error_code, error_type, and error_text.
  • B. Eliminate the to_char function because message_code is a varchar2 value.
  • C. To keep the remaining code from executing, add after the second line: RAISE FORM_TRIGGER_FAILURE;
  • D. Change all occurrences of message_code, message_type, and message_text to DBMS_error_code, DBMS_error_type, and DBMS_error_text.


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?

  • A. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null.
  • B. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to one of the credit rating values.
  • C. Create four radio buttons, and leave blank the value for the undetermined credit rating.
  • D. Choose a different type of input item, because radio groups do not allow entry and update of null values.


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?

  • A. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that "broke" the form.
  • B. Use a Key-Entqry trigger on the master block to redirect the focus to the detail block after the search criteria have been entered in the master block.
  • C. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.
  • D. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have the procedure handle the navigation.
  • E. Use a Key-Nxtblk trigger on the ORDERS block to cause navigation to the ORDER_ITEMS block. This will work because Key triggers can fire in Enter-Query mode and can call restricted built-ins such as GO_BLOCK().
  • F. Use a combination of Key-Entqry and Key-Exeqry triggers at form level to call generically written procedures to test where the current focus is and set global variables that a form-level Key-Nxtblk trigger can use to redirect the focus.


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?

  • A. Ensure that the current item is not hidden by the overlay canvas.
  • B. Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True.
  • C. In the Layout Editor, choose View Stacked Views. Then select the overlay canvas in the Stacked Canvases dialog box.
  • D. Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the first canvas listed under this node.
  • E. Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the last canvas listed under this node.


Answer : A

Page:    1 / 10   
Total 138 questions