Free 1Z0-151 Exam Dumps Preview

Controlling System Messages
You can prevent system messages from being issued, based on their severity level. FormsBuilder classifies every message with a severity level that indicates how critical or trivial the information is; the
higher the numbers, the more critical the message. There are six levels that you can affect.

Note: Suppressing Messages According to Their Severity
In a trigger, you can specify that only messages above a specified severity level are to be issuedby the form. You do this by assigning a value to the MESSAGE_LEVEL system variable. Formsthen issues only those messages that are above the severity level defined in this variable.The default value for MESSAGE_LEVEL (at form startup) is 0. This means that messages of all severities are displayed.

Both Chen and Popp are selected, so Multi-selection is set to Yes (not B). + and symbols are displayed, so Show Symbols is yes (not B, C, D). Allow Empty Branches is set to Yes (so A is ok), see note below.

Note: Setting Hierarchical Tree Item Properties
Hierarchical Tree properties include the following:
* Item Type: Must be set to Hierarchical Tree
* Allow Empty Branches:
Yes / No. No is the default.

If set to Yes, all leaf nodes will initially display in the tree with the plus sign (+) next to it, indicating that expansion is possible, even when there is nothing to expand. If set to Yes, the Show Symbols property must also be set to Yes.

If set to No, leaf nodes will not have an expand/collapse symbol

* Multi Selection: Whether multiple nodes may be selected at one time No is the default.
* Show Lines: Whether a hierarchical tree displays lines leading up to each node Yes is the default.
* Show Symbols: Whether a hierarchical tree should display + or - symbols in front of each branch node
* Record Group: Name of the record group from which the hierarchical tree derives its values
* Data Query: Specifies the query-based data source

There is a basic difference between canvas & windows is that a canvas is placeholder for several controls.
A window may contain several canvases.

When-Checkbox-Changed trigger Description Fires when an operator changes the state of a check box, either by clicking with the mouse, or using thekeyboard.
Definition Level: form, block, or item Legal Commands: SELECT statements, unrestricted built-ins, restricted built-ins

References:
Oracle Forms Developer, When-Checkbox-Changed trigger

This should be implemented as a master-detail form.

A: Note: FIND_MENU_ITEM built-in
Description
Searches the list of menu items and returns a menu item ID when it finds a valid menu item with the given name. You must define an appropriately typed variable to accept the return value.
Define the variable with a type of MenuItem.

Note 2:
FIND_ITEM built-in
Description
Searches the list of items in a given block and returns an item ID when it finds a valid item with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of Item.

Example (with FIND_MENU_ITEM, GET_MENU_ITEM_PROPERTY,
SET_MENU_ITEM_PROPERTY)
FIND_MENU_ITEM examples
/*
** Built-in: FIND_MENU_ITEM
** Example: Find the id of a menu item before setting
** multiple properties
*/ PROCEDURE Toggle_AutoCommit_Mode IS
mi_id MenuItem;
val VARCHAR2(10);
BEGIN mi_id := Find_Menu_Item('Preferences.AutoCommit');
/*
** Determine the current checked state of the AutoCommit ** menu checkbox item
*/ val := Get_Menu_Item_Property(mi_id,CHECKED);
/*
** Toggle the checked state
*/
IF val = 'TRUE' THEN
Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_FALSE);
ELSE
Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_TRUE);
END IF;
END;

C: You can use the attachable PL/SQL libraries to implement a flexible message function formessages that are displayed programmatically by the built-in routines MESSAGE orCHANGE_ALERT_MESSAGE, or by assigning a message to a display item from a triggeror procedure.
D: Creating Calculated Items
Change the Item Type to Display Item.
Set the Calculation Mode property to Formula.
Set the Formula property to the required formula.

Incorrect answers:
B: Display items and text items are fairly similar and share many of the same properties. The biggest difference between the two is that a user can navigate to a text item and change its value. This is not possible with a display item. As its name implies, it merely displays information.

Note: Display items do not allow any user interaction - they merely display data and never accept cursor focus.

Use a display item for the following situations:
* Null-canvas fields
* Context fields
* Fields that act as titles or prompts

This is a customized application message.

You can also build messages and alerts into your application:
* Application message: These are messages that you build into your application by using the MESSAGE built-in. The default display is on the message line. *Application alert: These are alerts that you design as part of your application, and issue to the operator for a response by using the SHOW_ALERT built-in.

A: Use $$DATE$$, $$DATETIME$$, and $$TIME$$ to obtain the local system date/time; use
$$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ to obtain the database date/time, which may differ from the local system date/time when, for example, connecting to a remote database in a different time zone. ,, Use these variables only to set the value of the Initial Value, Highest Allowed Value or Lowest Allowed Value property.

Incorrect answers:
B: This would work within a trigger.

The WLS managed server WLS_FORMS must be started.

ow to create LOV in Oracle forms?

List of Values(LOV) are used either when a selected list is too long and hence would not be appropriate for a drop down, but needs a search form to select the value.

Steps to create LOV functionality:

* Click on the LOV icon in the object navigator and choose a manual/automatic wizard. This will create a
record group.

* Open a search form in the Dialog Page
* Select values inside this form.

* Return selected values to the original page.

C: assume you put your gif in a directory /icon under your /forms on server, then in the registry.dat file, find the section containing sth below xxx.xxx.iconpath=

xxx.xxx.iconextension =,

set above iconpath=/icon

iconextension =gif

* Keyboard Navigable property
Description
Determines whether the end user or the application can place the input focus in the item during default navigation. When set to Yes for an item, the item is navigable. When set to No, Form Builder skips over the item and enters the next navigable item in the default navigation sequence. The default navigation sequence for items is defined by the order of items in the Object Navigator.
Applies to all items except chart items and display items

* Default
Yes
Usage Notes
If Enabled or Visible is set to No (PROPERTY_FALSE for runtime), then the items' or item instance's
Keyboard navigable property is effectively false. At runtime, when the Enabled property is set to PROPERTY_FALSE, the Keyboard_Navigable property is also set to PROPERTY_FALSE. However, if the Enabled property is subsequently set back to PROPERTY_TRUE, the keyboard Navigable property is NOT set to PROPERTY_TRUE, and must be changed explicitly.