Oracle 1z0-151

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?

You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of Object1. You want to be able to change the properties of Object2. However if you change Object1, you do not want Object2 to change.

Which method of reusing Object1 would be best for these requirements

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?

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?

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?

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:

SELECT orders_seq.NEXTVAL

INTO :orders.order_id

FROM SYS.dual;

Which statement is true about this code?

You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.

Which canvas types would be most appropriate in this scenario?

You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?

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?

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?

You are coding a When-Checkbox-Changed trigger.

Which statements are available for use in your code?

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.

What happens when you run the form from Forms Builder?

Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.

Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.

Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.

Possible navigation units that can occur during navigation of this form are:

1. Outside the form

2. The Human Resources form

3. The Departments block

4. The Employees block

5. The current Departments record

6. The current Employees record

7. The Department_Id item

8. The Employee_Id item

With the cursor in : Departments.Department_Id, the clerk clicks the :Employees.Employee_Id item.

What is the sequence of navigational unit movement that occurs

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties.

You want users to be able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.
However, when you test the form, you find that you are unable to close either window. What must you do to provide this functionality?

Identify a function of the Forms Servlet.