The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID. Several of the forms use LOVs that are based on the same query. You decide to centralize the creation of the record group to the entry form of the application, which opens all the other forms, for example, to open the inventories form, there is a When-Button Pressed trigger on the inventories button with the following code;

OPEN _FORM ('inventories');

in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group by

using the CREATE_GROUP_QUERY built in with the following arguments:

('warehouse_rg' , 'SELECT ALL WAREHOUSE.WAREHOUSE_ID, WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);

You also populate the record group in this trigger.

What must you do to make this record group available to the inventories form and the other forms?

A. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.

B. in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.

C. in the entry form, move the record group code to the beginning of the When-Button-Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.

D. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.

E. in the other forms, refer to the record group as: global.warehouse_rg.

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:

SELECT orders_seq.NEXTVAL INTO :orders.order_id FROM SYS.dual;

Which statement is true about this code?

A. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.

B. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.

C. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.

D. If the named sequence does not exist, it is automatically created the first time the code is called.

E. You should place this code a in a database trigger to minimize the gaps in Order IDs.

F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.

G. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.

You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.

Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has a When Button Pressed trigger that calls RAISE_SALARIES.

However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?

A. You are not connected to the database.

B. The stored program unit was not compiled with the debug information included.

C. The breakpoint should have been set in the When-Button-Pressed trigger, not in the stored program unit.

D. You cannot use the Forms Debugger to diagnose problems with stored program units.

You have the Orders form open in Forms Builder. You create an object group in the Orders form and try to drag various components in the Object Navigator to the object group.

Which two components will you be unable to place in the object group?

A. the Orders block of the Orders form

B. the Order_CV canvas of the Orders form

C. the When-New-Item- instance trigger of the Order_Items.Quantity item in the Orders form

D. the When-New Form-instance trigger of the Orders form

E. the Product_id item in the Order_Items block of the Orders form

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following

database trigger that fires before the update of Customer_Id:

BEGIN

If :old.customer_id != : new.customer_id then

RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!'); end if;

END;

You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error

dialog box that is shown in the Exhibit appears.

Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead

of the FRM- error message?

A. IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF

B. IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM); END IF;

C. IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;

D. IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM); END IF;

E. IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;

F. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM); END IF;