Oracle 1z0-151 Prüfungsfragen : Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.
Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has a When Button Pressed trigger that calls RAISE_SALARIES.
However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?

• A. The breakpoint should have been set in the When-Button-Pressed trigger, not in the stored program unit.
• B. The stored program unit was not compiled with the debug information included.
• C. You cannot use the Forms Debugger to diagnose problems with stored program units.
• D. You are not connected to the database.

You are implementing a JavaBean in a form, the bean has no visible component on the form when invoked, the bean displays an input text where users enter a zip code, the bean has a single method that returns a short weather forecast for that zip code as a character value.
How can you retrieve that value so that you can display it to the user?

• A. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_ITEM_EVENT in a When-Custom item Event trigger, and then use that value as an argument to the MESSAGE built in.
• B. Use FBEAN.REGISTER_BEAN as an argument to the MESSAGE built in to invoke the bean's method and return the value as a message displayed to the user.
• C. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-item-Event trigger, and then use that value as an argument to the MESSAGE built-in.
• D. Use FBEAN.REGISTER_BEAN to register the bean, so that when the user enters a zip code into the bean s input text, the value is automatically displayed in the bean area item.

The Orders form, whose properties have not been changed from the default, has two non- base table text items to display the sales representative's first and last names.
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?

• A. Code an On-Error trigger.
• B. Add the code to handle the FORM_TRIGGER_FAILURE exception.
• C. Move the code to a form-level When-Validate-Item trigger.
• D. Raise the TOO_MANY_ROWS exception.
• E. Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
• F. Change the form's validation Unit property to Record.
• G. Raise the FORM_TRIGGER_FAILURE exception.
• H. Add code to handle the TOO_MANY_ROWS exception.
• I. Code an On-Message trigger.

You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?

• A. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
  GO_BLOCK ('orders');
  ENTER_QUERY;
• B. You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.
• C. Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.
• D. Change the Key-Exeqry trigger to:
  IF :SYSTEM.MODE != 'ENTER-QUERY' THEN
  GO_BLOCK('orders');
  EXECUTE_QUERY;
  ELSE
  MESSAGE ('You cannot execute a query in this block');
  ENTER_QUERY;
  GO_BLOCK ('orders');
• E. Change the key-Exqry trigger to:
  IF : SYSTEM.MODE := 'ENTER-QUERY' THEN
  GO_BLOCK ('orders');
  EXECUTE_QUERY;
  ELSE
  MESSAGE ('you cannot execute a query for the Order_Items block'):
  END IF;
  Define the following Key-Entqry trigger for the Order_Items block:
  GO_BLOCK ('orders');
  ENTER_QUERY
• F. Add the following as the first of the key-Exqry trigger to Yes.
  SYSTEM.mode := 'NORMAL';
• G. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
  ENTER_QUERY;
  GO_BLOCK ('orders');

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER'
THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?

• A. in the first line of code, change the CV_ORDER to lowercase
• B. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
• C. in the first line of code, change the built-in to GET_ITEM_PROPERTY
• D. Chang the argument to the GO_BLOCK built-ins to uppercase
• E. Change the sequence of blocks in the Object Navigator
• F. Chang the Mouse Navigator property of the button to yes