Oracle 1z0-151 Exam Practice Questions (P. 4)

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?

You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts:
* A message to inform the user about being at the just record
* A warning about a potential conflict with the data just entered
* A message to display a validation error to the user
* A warning that the salary is out of range and that asks whether the user wants to correct it

You want the note symbol (
) to appear on alerts that display only informative messages, the warning symbol to appear on messages where you will allow the user to continue despite some data problem, and the alarm boll symbol to appear where the user will not be allowed to continue without correcting the situation that caused the alert to be displayed.
You want to define the minimum number of alerts possible and customize them at run time.
Which alerts should you define?

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.
After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:
FRM-10142: The HTTP Listener is not running on <host> at port 9001.
Please start the listener or check your runtime preferences.
What is one action that you can take to resolve this error?

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

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?