nerdexam
Oracle

1Z0-151 · Question #76

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…

The correct answer is A. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument. Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of an expression. For example: DECLARErg_id RecordGroup;BEGIN rg_id := CREATE_GROUP_FROM_QUERY ('employee_rg', 'SELECT id,first_name,last_name,sal FROM employee');

Working with Record Groups and Parameters

Question

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?

Options

  • Ain the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument
  • Bin the entry form, move the record group code to the end of the When-Button-Pressed triggers for
  • Cin the entry form, move the record group code to the beginning of the When-Button-Pressed triggers
  • Din the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value
  • Ein the other forms, refer to the record group as: global.warehouse_rg.

How the community answered

(56 responses)
  • A
    79% (44)
  • B
    5% (3)
  • C
    2% (1)
  • D
    11% (6)
  • E
    4% (2)

Explanation

Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of an expression. For example: DECLARErg_id RecordGroup;BEGIN rg_id := CREATE_GROUP_FROM_QUERY ('employee_rg', 'SELECT id,first_name,last_name,sal FROM employee');

Topics

#record groups#OPEN_FORM#scope argument#multi-form applications

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-151 Practice