Multiple choice

The Department form is a part of a multiform application that also includes the Customer and Orders forms. The Department form must include a query-based PRODUCT Record Group. All three forms must be able to access the PRODUCT Record Group. Which built-in should be used to create the PRODUCT Record Group?

  1. CREATE_GROUP('PRODUCT')

  2. CREATE_GROUP('PRODUCT', FORM_SCOPE)

  3. CREATE_GROUP('PRODUCT', GLOBAL_SCOPE)

  4. CREATE_GROUP_FROM_QUERY('PRODUCT', 'Select id, desc from products', GLOBAL_SCOPE)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To share a Record Group across multiple forms in Oracle Forms, use CREATE_GROUP_FROM_QUERY with GLOBAL_SCOPE. This creates the group at the application level rather than form-level scope, making it accessible to Department, Customer, and Orders forms. FORM_SCOPE would restrict it to the creating form, while CREATE_GROUP without a query doesn't populate data.

Keep practicing — related questions