Free Oracle 1z1-151 Exam Dumps Questions & Answers

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.
You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

• A.  The MESSAGE () built-in is not allowed in validation triggers.
• B.  The validation unit of the form needs to be changed.
• C.  Validation for the Customer_Id item failed.
• D.  The form is in Enter-Query mode.
• E.  The item is using an LOV for validation.
• F.  There is a syntax error in the call to the MESSAGE() built-in.

View the exhibit.

In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No.
You are coding a When-Button-Pressed trigger for the First Record button with the following code:
SCROLL_UP;
WHILE FORM_SUCCESS LOOP
SCROLL_UP;
END LOOP;
What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?

• A.  The form goes into an infinite loop and has to be killed by using operating system commands.
• B.  A runtime error is encountered because there is no scroll bar for the block.
• C.  The display scrolls so that the first record is visible, bur the cursor stays on the last visible record, which should be record 10.
• D.  Because there is no scroll bar, the cursor navigates only as far as the first visible record, which is record 63.
• E.  The cursor successfully navigates to the first record.
• F.  internal navigation to the first record occurs, but the visible cursor remains on record 72.
  You should add the SYNCHRONIZE command to synchronize the display with the internal state of the 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 "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 = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• B.  IF ERROR_CODE = 40509 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF
• C.  IF ERROR_CODE = 40509 THEN
  MESSSAGE (SQLERRM);
  END IF;
• D.  IF ERROR_CODE = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;
• E.  IF ERROR_CODE = 06512 THEN
  MESSSAGE (SQLERRM);
  END IF;
• F.  IF ERROR-CODE = 20101 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF;

When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.

• A.  True
• B.  False

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 other forms, refer to the record group as: global.warehouse_rg.
• 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 When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.
• D.  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.
• E.  in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.