You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?

• A. Pre Query trigger
• B. You need to define a master-detail relation so that the item is populated automatically.
• C. When-New-Form-instance trigger
• D. Post-Query trigger
• E. When New-Item-instance trigger

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

• A. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.
• B. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.
• C. No. It is too late to perform a rollback at this stage because the update has already been applied.

The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button that runs the Orders form sets a global variable to the current customer ID.
The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:
DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');
IF: GLOBAL.customer_id IS NOT NULL
THEN
SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id =
' | | :GLOBAL.CUSTOMER_id);
END IF;
EXECUTE_QUERY
You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.
What changes must you make to the code so that the menu code functions as it does in the form?

• A. Change both occurrence of :GLOBAL.customer_id to 'GLOBAL.customer_id'.
• B. Change both occurrence of :GLOBAL.customer_id to NAME_IN
  ('GLOBAL.customer_id').
• C. Change 'GLOBAL.customer_id' in line 1 to :GLOBAL.customer_id.
• D. You cannot add this type of code in the menu because it refers to the items on the form that cannot be referenced from a menu.
• E. You do not need to change anything; the code compiles and functions correctly in the menu item.

View the Exhibit.

You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.
What is the reason for this?

• A. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.
• B. You cannot drag a block to an object group.
• C. You cannot drag a canvas to an object group.
• D. You cannot drag multiple types of objects to an object group at the same time.
• E. You need separate object groups for different types of objects.

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.
Which property setting accomplishes this requirement?

• A. Enabled = No; Keyboard Navigable = Yes
• B. Enabled = No; Keyboard Navigable = No
• C. Automatic Skip = Yes
• D. Enabled = Yes; Keyboard Navigable = No
• E. Enabled = Yes; Keyboard Navigable = Yes