Which three are valid ways to populate a display item?
A, C, D
Explanation:
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
You must be careful when coding a When-Button-Pressed trigger, because it does not accept
restricted built-ins.
B
Explanation:
The When-Button-Pressed trigger:
* Fires when the operator clicks a button
* Accepts restricted and unrestricted built-ins
* Is used to provide convenient navigation, and to display LOVs and many other frequently used
functions
An LOV must be displayed several times in your form; therefore, good performance when displaying
LOV is essential. In a When-New-Form-instance trigger, you want to save the ID of the LOV in a global
variable so that you can use it in any code to display the LOV.
Which built-in would you use to get the ID of the LOV?
B
Explanation:
Referencing Objects by Internal ID
Finding the object ID:
lov_id := FIND_LOV('my_lov')
The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for
the customer. The file should be created on the user's computer so that it can be printed with the
local printer.
Which WebUtil package would you use to implement this requirement?
C
Explanation:
Note: Performing OLE Automation on the Client
You can use any OLE2 package on the client by prefixing it with CLIENT_. You can see the list of the
OLE2 package procedures and functions in the Forms Builder ObjectNavigator under the Built-in
Packages node.
Note 2: With WebUtil, you can do the following on the clientmachine: open a file dialog box, read
and write image or text files, execute operating system commands, perform OLE automation, and
obtain information about the client machine
View the Exhibit.
What four facts can you determine by examining the Object Navigator?
BCHG
When users enter address information, you want them to be able to select the state from a static list
of values. You have not used a list of states before, and there is no database table that contains state
information.
What is the first step in creating such a list of values as quickly as possible?
A
Explanation:
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.
Customers log in to your Orders application by using their customer ID, which is saved as a global
variable. When the Orders form first comes up, you want it to be populated with the customer's
orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger
that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are
shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another
customer's orders?
B
Explanation:
Note: EXECUTE_QUERY procedure
Clears the current block, opens a query, and fetches anumber of selected records. If there are
changes tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE-
QUERYprocessing
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?
B, C
Which three statements are true about the PL/SQL Packages panel in the Forms debugger?
A, B, C
Explanation:
PL/SQL Packages Panel: This panel is used only to browse and examine the PL/SQL packages which
are been instantiated while executing the form.
View the Exhibit.
You are creating a menu for use with several forms. You create the structure of the menu in the
Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?
D
Explanation:
MENU3 and ITEM5_MENU are menus.