Online Access Free 1z0-151 Exam Questions

View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.
You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:
1. Displays a message to indicate which trigger is firing for which record?
2. Does the thing (either updates, deletes, or inserts)
The other triggers simply display a message, indicating the trigger that is firing.
You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?

• A.Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.
• B.Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.
• C.Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.
• D.Delete the "On-" triggers; these triggers remove default processing, including array processing.

Iin an Order Entry form, the Order_Items block has a text item called Shipping Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.
Assuming that the following are defined, which three are valid settings for the initial Value = property of the Shipping_Date Item?

• A.:Orders.Order_Date + 3
• B.:PARAMETER.SHIP
• C.:GLOBAL.SHIP_DATE
• D.$$DBDATE$$
• E.ORDER_ITEMS_SEQ
• F.SYSDATE

To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

• A.On-Query
• B.When-New-Block-instance
• C.Pre-Query
• D.Post-Query
• E.When-New-Form-instance

View the Exhibit.

What four facts can you determine by examining the Object Navigator?

• A.You cannot delete order items without deleting the order.
• B.The Order_Items block is a master block.
• C.If you delete an order item, all of its associated inventory items are deleted.
• D.The Orders block is a detail block.
• E.If an order is deleted, all of its order items are deleted.
• F.The Orders block is a master block.
• G.You can delete an order without deleting its order items.
• H.The inventories block is a master block.
• I.The Order_Items block is a detail block.
• J.An order can be deleted only if it has no order items.

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 "FRM-40509: 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 = 06512 THEN
  MESSSAGE (SQLERRM);
  END IF;
• B.IF ERROR-CODE = 20101 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF;
• C.IF ERROR_CODE = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;
• D.IF ERROR_CODE = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• E.IF ERROR_CODE = 40509 THEN
  MESSSAGE (SQLERRM);
  END IF;
• F.IF ERROR_CODE = 40509 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF